| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.misc
|
|||
|
|||
Summing not summing
"Harlan Grove" wrote in message ... "Bob Phillips" wrote... "Harlan Grove" wrote in message "Bob Phillips" wrote... Try this array formula =SUM(--D2:D6) ... Should have used =SUMPRODUCT(--D2:D6) No I shouldn't, array SUM works. True, but I meant in the sense of avoiding unnecessary follow-up and responses when the OP failed to enter your SUM formula as an array formula. Care to check the frequency of OPs failing to catch the 'array formula' caveats in responses they receive? 'Course if you like the unnecessary addition back & forth . . . Almost as much as your good self <bg |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Summing | Excel Worksheet Functions | |||
| PivotTable and summing/not summing | Excel Discussion (Misc queries) | |||
| summing up | Charts and Charting in Excel | |||
| Summing all BUT one... | Excel Worksheet Functions | |||
| Help with summing | Excel Worksheet Functions | |||
Hybrid Mode
