Formulas

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

First, I have an excel document that I use for daily accounting. I use one
worksheet for each day. On each day I have several columns for various
products we sell. Is there a way to have a worksheet collect the data from
certain columns in each worksheet and total it? For example, I want to know
how many products in category A I sold over the month. Can I have one
worksheet where it takes the data from the other 31 worksheets and totals it?
I don't know how to arrange a formula to do that. Is it possible?
 
The best way to do this is to have the sum in the SAME cell on each
worksheet and then use this idea.

=sum(firstsheet : lastsheet!a1)
 
If your data to sum is in the same cell on each sheet you can use a 3D
reference.

=SUM(Sheet1:Sheet31!$H$26)


Gord Dibben MS Excel MVP
 

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

Return data from catagory 2
Pull data from different worksheets/tab into one Pivot Table 3
How to ignore a column of numbers in Grand Total for rows 1
how to link multiple columns to multiple worksheet totals / functi 5
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
How to sum by month 8
Copy formula from one worksheet to another to get value in 2nd wks 1
COUNTIF: everything in a row larger than zero over multiple worksh 1

Back
Top