Hi

Try something like this:
=SUMPRODUCT((D7:G70)*(D7:G7))

AndyB

"Powlaz" wrote in message
...
I'm looking to total a range of cells ONLY if they have a value of 0 or
more
entered in them. In plain english:

Sumif A1 is =0
Sumif A2 is =0
Sumif A3 is =0

and so on. Where every cell in the range must have a value of 0 or more
entered before the function will return a result. How do I do this?

Thanks,

PO