| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula Help - Not sure which one I need! SUMIF I think?! | Excel Discussion (Misc queries) | |||
| Nesting a sumproduct formula within a sumif formula. | Excel Discussion (Misc queries) | |||
| multiply formula where 1 cell has a (sumif) formula as a result | Excel Worksheet Functions | |||
| Embed AND formula in SUMIF formula | Excel Discussion (Misc queries) | |||
| Is there a MAXIF formula similar to the SUMIF formula? | Excel Discussion (Misc queries) | |||
Hybrid Mode
