Formulas
 

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?

Formulas
 

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)

--
Don Guillett
SalesAid Software

"Stephanie" wrote in message
...
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?

Formulas
 

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

On Thu, 6 Jul 2006 07:36:01 -0700, Stephanie
wrote:

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?