Transfer the total of mutiple entries in a sheet to another sheet in the same file

[Pramod]

How to transfer the total of multiple of multiple entries in a sheet to
another shet in the same file.

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

 

[JE McGimpsey]

A little more detail would probably help in getting you an appropriate
response.

 

[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 **