ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Invoice Template Help (https://www.excelbanter.com/excel-programming/388480-invoice-template-help.html)

Heather

Invoice Template Help
 
We have an invoice template set up in Excel. We want to continue showing the
total for each individual item in the total column, but at the bottom where
we have total material, sales tax, and the total balace due broke out, we
want to keep some of those boxes blank. What we want is a the total material
and sales tax boxes to stay blank, but a total of the two boxes to appear in
the total due box.

How would I do this? Thanks for any help.

Heather

Don Guillett

Invoice Template Help
 

Don't want clients to see it huh, try
=sum(d2:d22)*1.085
--
Don Guillett
SalesAid Software

"Heather" wrote in message
...
We have an invoice template set up in Excel. We want to continue showing
the
total for each individual item in the total column, but at the bottom
where
we have total material, sales tax, and the total balace due broke out, we
want to keep some of those boxes blank. What we want is a the total
material
and sales tax boxes to stay blank, but a total of the two boxes to appear
in
the total due box.

How would I do this? Thanks for any help.

Heather




All times are GMT +1. The time now is 07:16 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com