Sum Problem requiring help
On Apr 29, 9:27 pm, "NoodNutt" wrote:
Hi all
What I am trying to achieve is to sum each cell in my range that has a value
either 0 or 1, but if a cell is "", then don't sum those cells.
=Sum($B$7:$B$10,$I$6,$I$8:$I$10,$P$6:$P$7,$P$9:$P$ 10,$W$6:$W$8,$W$10,$AD$6:$AD$9)
Tried this but am wrong
=Sum(Product($B$7:$B$10,$I$6,$I$8:$I$10,$P$6:$P$7, $P$9:$P$10,$W$6:$W$8,$W$10,$AD$6:$AD$9,<0),"")
Need some guidance please.
TIA
Mark.
Ok, summing blank cells returns 0, so that doesn't matter. Summing 0
returns 0, so that doesn't matter. It sounds like all you really want
is to count the number of 1s that are in these ranges, yes? What else
might be in those cells, and other adjacent cells?
Maybe just =COUNTIF(B1:AD10,"1"), you may not need the tricky list of
ranges you have.
|