need help with sum formula

[chrisnsmith]

I have a worksheet with columns D thru M. In column M I have the following
sum formula, H-I. This formula is simple but what I need is a formula that
will return no value if cells D thru M have no entries.

What formula should I use?

 

[Fred Smith]

Use Count -- it will ignore blanks. As in:

=if(count(Range)>0,sum(YourRange),"")

Regards,
Fred/

 

[Shane Devenshire]

Hi,


=IF(SUM(H1:I1),SUM(H1:I1),"")

This will work if when the two cells are 0 you will be happy with a blank
entry. If not

=IF(COUNT(H1:I1),SUM(H1:I1),"")

 

[chrisnsmith]

Thanks Fred,
This was just what I needed.

Use Count -- it will ignore blanks. As in:

=if(count(Range)>0,sum(YourRange),"")

Regards,
Fred/