Where do I put SUMIF...revised

rsw8679 · Mar 29th, 2002, 02:10 PM

First a word of thanks to all that have given advice over the last few days. I finally got my function to work on one spread sheet now I modified it to use with different data and need to add a SUMIF,

The equation so far is this: =IF(ISERROR(VLOOKUP($A23&D$3,RIS_GR_MAINS!$D$2:$E$503,2,FALSE)),"HELP",VLOOKUP($A23&D$3,RIS_GR_MAINS!$D$2:$E$503,2,FALSE))

The lookup ($A23&D$3)=19176, this appears twice on the referenced sheet one value is 1000 the other is 500. I need to add a SUMIF in my function to find all instances of $A23&D$3 and add them together, in this case return 1500. Please ignore the term "HELP" in the equation, it is a flag for me elsewhere and will be replaced with "" when everything works properly.

Any takers? Happy Easter to all!!

[ This Message was edited by: rsw8679 on 2002-03-29 13:57 ]

[ This Message was edited by: rsw8679 on 2002-03-29 14:18 ]

Dave Patton · Mar 29th, 2002, 04:25 PM

Vlookup will just locate the first instance that meets your lookup value.

If you clearly describe your challenge, someone is sure to provide a good alternative.

A clear concise example with the results that you expect is often very useful.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 29th, 2002, 02:10 PM	#1
rsw8679 New Member Join Date: Mar 2002 Posts: 5	First a word of thanks to all that have given advice over the last few days. I finally got my function to work on one spread sheet now I modified it to use with different data and need to add a SUMIF, The equation so far is this: =IF(ISERROR(VLOOKUP($A23&D$3,RIS_GR_MAINS!$D$2:$E$503,2,FALSE)),"HELP",VLOOKUP($A23&D$3,RIS_GR_MAINS!$D$2:$E$503,2,FALSE)) The lookup ($A23&D$3)=19176, this appears twice on the referenced sheet one value is 1000 the other is 500. I need to add a SUMIF in my function to find all instances of $A23&D$3 and add them together, in this case return 1500. Please ignore the term "HELP" in the equation, it is a flag for me elsewhere and will be replaced with "" when everything works properly. Any takers? Happy Easter to all!! [ This Message was edited by: rsw8679 on 2002-03-29 13:57 ] [ This Message was edited by: rsw8679 on 2002-03-29 14:18 ]

Mar 29th, 2002, 04:25 PM	#2
Dave Patton Board Regular Join Date: Feb 2002 Location: Calgary, Alberta Canada Posts: 2,065	Vlookup will just locate the first instance that meets your lookup value. If you clearly describe your challenge, someone is sure to provide a good alternative. A clear concise example with the results that you expect is often very useful.