sum a range and then test its result ?

[lindasf]

Hi ,

Is there a way to sum a range and then test its result ?

For example: sum g5:g17 and then test for 0.

* If the result is 0, insert a blank/space into the cell.

* If the result is NOT 0, leave the sum that was just calculated (e.g
- g5:g17) in the cell.

Thx.

lindas

 

[Patti]

Is this what you're looking for:

=IF(SUM(G5:G17)=0,"",SUM(G5:G17))

 

[Biff]

Hi lindasf!

Try this:

=IF(SUM(G5:G17)=0,"",SUM(G5:G17))

If the sum is zero, it will leave the cell blank but don't
confuse that with being an empty cell.

Biff

 

[lindasf]

Thx Patti!
That works perfectly!

lindas