How to sum total automatically in more than one sales invoices

G

Guest

In Excel 2000 General templates - Sales invoice- ( I have created sales
invoice temlpate which suites my requirement) How to get sum of TOTAL of
more than one invoices which we issue in a day. For examlple , If I issue 10
sales invoices in a day , I should be able to get the sum total of the amount
of 10 invoices automatically in a cell. What functions/ codes should I use to
achieve my requirement. At present I am mechanically adding the total of ten
sales invoices to get the sum . I would like to get the sum automatically.
Kindly help me.
 
G

Guest

Hi,

You may use the sim function to achieve your result. For example, if you
have data in the range A1:A10 and you want the result in A11, then use the
following formula in cell A11

=sum(A1:A10)

Regards,

Ashish Mathur
 

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

Similar Threads

Adding values for all rows in a range 6
Apply Pament to invoices in form 0
How can I use a formula to calculate a running sub-total in excel 2
How to ignore a column of numbers in Grand Total for rows 1
Conditional Sum? 2
Need formula to calculate subtotal before sales tax 4
TRUE/FALSE 5
Excel How to create a Accounts Receivable to calculate days in which payments against invoice are received 0

Top