| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Summing Based on Conditions using Array
I need to sum an array {=sum(a4:a8/b4:b8)} which is based on two conditions,
that the individual cell dates associated with the array range is less than a specified date and after another specified date. I've tried numerous formulas without using the and convention, but can't seem to get it to work. Thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Summing Based on Conditions using Array
I would expect a SUMPRODUCT() formula would be required.
-- "Actually, I *am* a rocket scientist." -- JB (www.MadRocketScientist.com) Your feedback is appreciated, click YES if this post helped you. "Jamie" wrote: I need to sum an array {=sum(a4:a8/b4:b8)} which is based on two conditions, that the individual cell dates associated with the array range is less than a specified date and after another specified date. I've tried numerous formulas without using the and convention, but can't seem to get it to work. Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Array - Count based on 3 conditions | Excel Discussion (Misc queries) | |||
| shade cells based on conditions - i have more than 3 conditions | Excel Worksheet Functions | |||
| Grand total based on conditions within an array | Excel Discussion (Misc queries) | |||
| Conditionally summing cells based on conditions in other rows | Excel Worksheet Functions | |||
| Summing an array based on text condition | Excel Discussion (Misc queries) | |||
Linear Mode
