Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum / Sumif
Hi,
The following formula works: =SUM(H1,F1,D1,D3,E3,G3) How do I do the same with Sumif? (with whatever criteria) Regards - Dave. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum / Sumif
example
-- Don Guillett Microsoft MVP Excel SalesAid Software "Dave" wrote in message ... Hi, The following formula works: =SUM(H1,F1,D1,D3,E3,G3) How do I do the same with Sumif? (with whatever criteria) Regards - Dave. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum / Sumif
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum / Sumif
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum / Sumif
Hi TM,
Thanks. Works a treat. But ouch! What what was MS thinking - making the simple things difficult? Regards - Dave. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum / Sumif
MS was thinking that most people would sum consecutive cells. They were
correct. Regards, Fred "Dave" wrote in message ... Hi TM, Thanks. Works a treat. But ouch! What what was MS thinking - making the simple things difficult? Regards - Dave. |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum / Sumif
Ouch again. That hurts.
Seriously though, I was really wondering why SUM handled non-consecutive cells so well, while SUMIF handled them so badly... Daev. "Fred Smith" wrote: MS was thinking that most people would sum consecutive cells. They were correct. Regards, Fred |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum / Sumif
Good point. Sum was obviously written by someone who cared about the end
user, and was interested in handling as many situations as possible. It, for example, is one of the few functions which handle 3D ranges (Sheet1:Sheet3!A1:B6). Unfortunately, MS did not insist on the same quality for most of the other functions, including Sumif. And, more annoying, they haven't bothered to add this functionality in future releases, included 2007. Regards, Fred. "Dave" wrote in message ... Ouch again. That hurts. Seriously though, I was really wondering why SUM handled non-consecutive cells so well, while SUMIF handled them so badly... Daev. "Fred Smith" wrote: MS was thinking that most people would sum consecutive cells. They were correct. Regards, Fred |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum / Sumif
Hi FS,
Thanks for the info on summing 3D ranges. I didn't know that could be done. Always learning. Dave. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sumif for multi conditions. i.e sumif(A1:A10,"Jon" and B1:B10,"A" | Excel Worksheet Functions | |||
SUMIF?? | Excel Worksheet Functions | |||
Embedding a Sumif in a sumif | Excel Worksheet Functions | |||
nested sumif or sumif with two criteria | Excel Worksheet Functions | |||
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions |