| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
On an invoice - with sums equations - don't want zero values to sh
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
On an invoice - with sums equations - don't want zero values to sh
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
On an invoice - with sums equations - don't want zero valuesto sh
Mike,
since he wants to multiply, there should be values in both columns and then either use PRODUCT() or * =IF(AND($A10,$C10),A1*C1,"") Regards, Dominik. Mike H schrieb: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Getting Sums of Values | Excel Worksheet Functions | |||
| Equations with numbers and letter values | Excel Discussion (Misc queries) | |||
| LOOKUP FUNCTION WITH SUMS VALUES | Excel Discussion (Misc queries) | |||
| Calculating Average Values Using Arithmetic Equations | Excel Worksheet Functions | |||
| Calculating Average Values Using Arithmetic Equations | Excel Worksheet Functions | |||
Linear Mode
