Slight change:

=IF(COUNTIF(SumRange,"=0")=ROWS(SumRange),SUM(Sum Range),0)


"Kevin Vaughn" wrote:

This worked for me. First I named the range I wanted to sum SumRange
(clever, eh?) I then used this formula:

=IF(COUNTIF(SumRange,"0")=ROWS(SumRange),SUM(SumR ange),0)


"Powlaz" wrote:

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