Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to sum total automatically in more than one sales invoices
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. |
#2
|
|||
|
|||
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 "Dr.H.Subramanian" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I automatically total and flag charges when they reach a s. | Excel Discussion (Misc queries) | |||
how do I set up a total amount automatically in excel | Excel Worksheet Functions | |||
in excel, how do i set up a spread sheet that automatically total. | New Users to Excel | |||
Total remaining formula | Excel Worksheet Functions | |||
Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions |