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.