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?