Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 23rd 05, 06:16 AM
Dr.H.Subramanian
 
Posts: n/a
Default 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   Report Post  
Old May 23rd 05, 10:44 AM
Ashish Mathur
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I automatically total and flag charges when they reach a s. slw66 Excel Discussion (Misc queries) 4 February 22nd 05 08:38 PM
how do I set up a total amount automatically in excel sue Excel Worksheet Functions 2 January 23rd 05 05:35 PM
in excel, how do i set up a spread sheet that automatically total. jgus New Users to Excel 1 January 14th 05 04:10 AM
Total remaining formula jbsand1001 Excel Worksheet Functions 2 January 6th 05 04:17 PM
Subtotal of Subtotal displays Grand Total in wrong row Thomas Born Excel Worksheet Functions 5 January 6th 05 01:46 PM


All times are GMT +1. The time now is 01:59 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017