Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
odd sumif formula
This SUMIF formula seems weird: =SUMIF(E20:P63,,G23:G579)
1) The two ranges given overlap. Is that a problem? 2) It has no criteria? What's the purpose of using SUMIF here? Why not just SUM(E20:P63,G23:G579)? Am I missing something? Thanks, Dave -- Brevity is the soul of wit. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
help with sumif formula with multiple critera | Excel Worksheet Functions | |||
Reusing formula | Excel Discussion (Misc queries) | |||
Match then lookup | Excel Worksheet Functions | |||
formula (perhaps sumif?) | Excel Discussion (Misc queries) | |||
Array Formula w/ Multiple SumIf Criteria | Excel Worksheet Functions |