Remember Me?

#1
May 23rd 05, 06:16 AM
 Dr.H.Subramanian Posts: n/a
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
May 23rd 05, 10:44 AM
 Ashish Mathur Posts: n/a

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.

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post slw66 Excel Discussion (Misc queries) 4 February 22nd 05 09:38 PM sue Excel Worksheet Functions 2 January 23rd 05 06:35 PM jgus New Users to Excel 1 January 14th 05 05:10 AM jbsand1001 Excel Worksheet Functions 2 January 6th 05 05:17 PM Thomas Born Excel Worksheet Functions 5 January 6th 05 02:46 PM

All times are GMT +1. The time now is 06:56 AM.