How to sum total automatically in more than one sales invoices

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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
Excel How to create a Accounts Receivable to calculate days in which payments against invoice are received 0
Conditional Sum? 2
How to ignore a column of numbers in Grand Total for rows 1
How can I use a formula to calculate a running sub-total in excel 2
Formula Help needed 2
True or False 3
Re-calulating totals based on "days old" 1

Back
Top