Hi,

Modify your formula like this which requires at least 1 numeric value before
the sum is evaluated

=IF(COUNT(A1:C1),SUM(A1:C1),"")

Mike

"DaveG" wrote:

Hi,
I have done an automated invoice sheet with 4 columns and ten rows.
The four columns are labelled: number of units, description, price per item
and total.
The auto sum calculation shown in column 4 for each row is configured to
give me the monetary value of columns 1 x column 3.
My dilemma is this: having added the auto sum function to every row I now
have $00.00 showing in every row I have not added goods for which makes the
sheet look ridiculous.
Is there a way of telling the sheet to display the monetary totals only
where there are products entered?
Thanks, Dave