| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sumproduct calculation does not calculate entire range
I have tweaked this formula to this point
=SUMPRODUCT((Zone=B8)*(O2scfm0), O2scfm) and it works for the first few cells I want a sum in. It does not want to calc the remainder of the range (Zone). I completed about 30 zones on my Room Data tab, and went back to see if it worked, but it did the first few rows correctly then nothing below that, why? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HOW TO CALCULATE AGES IN AN ENTIRE COLUMN?? | Excel Discussion (Misc queries) | |||
| HOW DO I CALCULATE THE NUMBER OF RESULTS FROM AN ENTIRE ROW | Excel Worksheet Functions | |||
| When entering data into a range of cells, select the entire range. | Excel Discussion (Misc queries) | |||
| I would like to apply the same calculation to an entire row | Excel Worksheet Functions | |||
| How do I make an entire column do the same calculation across a r. | Excel Discussion (Misc queries) | |||
Threaded Mode
