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

D

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
 
M

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
 
D

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top