how to transfer the total of multiple entries in a sheet to another in the same file?

P

PRAMOD

We have 31 sheets in a file for maintaining day to day sales record for
different customers. The TOP sheet contain the summary showing the total
sales of all the customer.
Now the problem is that say for example in sheet number 9, customer "ABC
PERIPHERAL" buys 7 different items from us in 5 different transactions
in a day ( 5 invoices are issued). How do we get the total sales value
for the 5 invoices issued carried forward to the top sheet?

Please kindly help me.


** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Software!
http://www.ozgrid.com/Services/excel-software-categories.htm **
 

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

Transfer the total of multiple entries in a sheet to another sheet in the same file. 1
Transfer the total of mutiple entries in a sheet to another sheet in the same file 2
Referencing dates against Products, in order to find the Qty. Without using Column referencing 1
Macro to add Multiple rows in same sheet 1
To find out the total number of hrs worked in a week 2
How to ignore a column of numbers in Grand Total for rows 1
Looking for a way to Force Successor Task to next workday IF 'x' amount of time left in workday 0
How can I use a formula to calculate a running sub-total in excel 2

Top