need help with sum formula
 

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?

need help with sum formula
 

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

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

Regards,
Fred/

"chrisnsmith" wrote in message
...
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?

need help with sum formula
 

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),"")

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"chrisnsmith" wrote:

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?

need help with sum formula
 

Thanks Fred,
This was just what I needed.

"Fred Smith" wrote:

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

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

Regards,
Fred/

"chrisnsmith" wrote in message
...
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?