| Home |
| Search |
| Today's Posts |
|
|
|
#1
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
