help with sumif formula
 

i was just wondering why this only brings back the value of G, and not the
others.

=SUMIF(I$4:I$18,{"G","H","K","M"},J$4:J$18)

--


Gary

help with sumif formula
 

got sumproduct to work, though

=SUMPRODUCT(($I$3:$I$18={"G","H","K","M"})*($J$3:$ J$18))

--


Gary


"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
i was just wondering why this only brings back the value of G, and not the
others.

=SUMIF(I$4:I$18,{"G","H","K","M"},J$4:J$18)

--


Gary

help with sumif formula
 

Gary

You need to wrap the Sumif with a function that expects/can handle a
array eg:

=SUM(SUMIF(I$4:I$18,{"G","H","K","M"},J$4:J$18))

which is more work than using Sumproduct in the first place

--
RichardScholla
-----------------------------------------------------------------------
RichardSchollar's Profile: http://www.officehelp.in/member.php?userid=524
View this thread: http://www.officehelp.in/showthread.php?t=126993

Posted from - http://www.officehelp.i

help with sumif formula
 

ok, thanks, that makes sense.

--


Gary


"RichardSchollar" wrote in message
...

Gary

You need to wrap the Sumif with a function that expects/can handle an
array eg:

=SUM(SUMIF(I$4:I$18,{"G","H","K","M"},J$4:J$18))

which is more work than using Sumproduct in the first place!


--
RichardSchollar
------------------------------------------------------------------------
RichardSchollar's Profile: http://www.officehelp.in/member.php?userid=5248
View this thread: http://www.officehelp.in/showthread.php?t=1269932

Posted from - http://www.officehelp.in