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?