| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum based on Range Criteria
I have a formula that I created based on other examples that I saw in the
discussion group. Just wondering if this is the simplest formula for this example. I am using this formula to sum all values in column BC when values in BD are greater/equal to 500 but less than 600. =SUMPRODUCT(--(BD$5:BD$98=500),--(BD$5:BD$98<600),BC$5:BC$98) Also, can someone explain what the -- prior to the criteria does? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Summing a range based on value criteria | Excel Discussion (Misc queries) | |||
| Any way to have a dynamic range for ranking, based on criteria? | Excel Worksheet Functions | |||
| color a range of cells based on a criteria | Excel Discussion (Misc queries) | |||
| Bucketing data based on DATE Range criteria | Excel Discussion (Misc queries) | |||
| MIN within range based on criteria | Excel Discussion (Misc queries) | |||
Threaded Mode
