On an invoice - with sums equations - don't want zero values to sh

[DaveG]

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

 

[Mike H]

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

 

[Dominik Petri]

Mike,

since he wants to multiply, there should be values in both columns and
then either use PRODUCT() or *

=IF(AND($A1>0,$C1>0),A1*C1,"")

Regards,
Dominik.