need help with sum formula

  • Thread starter Thread starter chrisnsmith
  • Start date Start date
C

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?
 
Use Count -- it will ignore blanks. As in:

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

Regards,
Fred/
 
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),"")
 
Back
Top