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

"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.