Can I use Sum Product across multiple tabs within a workbook?

B

BillyHank

I have a column of data with a variety of identifier codes. In each row next
to the ID codes is data. There are several tabs within my workbook with
similarly constructed data bases. Can I use Sum Product to summarize the
data across the multiple tabs that match each of the id codes? If not, is
there another way?
 
B

Bernard Liengme

Tell us more about how the data is set our in the worksheets and what you
wish to do
("Tabs" are the little things you click to open worksheets)
best wishes
 
T

Teethless mama

Tabs ? Are you referred to Work sheets?
In this case:
=SUM(SUMIF(INDIRECT("Sheet"&{1,2,3}&"!A2:A10"),"A",INDIRECT("Sheet"&{1,2,3}&"!B2:B10")))

Adjust to suit your needs
 
B

BillyHank

Here is an example of one of the data tables I have in many Worksheets.

FY08 FY09 FY10 FY11 Total

Jones co 868 Hrs 493 Hrs 431 Hrs 99 Hrs 3,015 Hrs
Smith Inc 973 Hrs 498 Hrs 389 Hrs 96 Hrs 3,053 Hrs
Thomas, LLP 1,369 Hrs 1,271 Hrs 1,079 Hrs 1,073 Hrs 3,534 Hrs
Mike's Wicked Co. 566 Hrs 480 Hrs 389 Hrs 389 Hrs 1,920 Hrs
Company A 200 Hrs 115 Hrs 24 Hrs 24 Hrs 369 Hrs
My Company 34 Hrs 45 Hrs 45 Hrs 45 Hrs 182 Hrs
Lowell's Labs 18 Hrs 24 Hrs 24 Hrs 24 Hrs 96 Hrs
Rick's Research 31 Hrs 41 Hrs 41 Hrs 41 Hrs 165 Hrs
Sonofacompany 0 Hrs 13 Hrs 162 Hrs 162 Hrs 364 Hrs

Total 4,439 Hrs 3,830 Hrs 2,755 Hrs 2,578 Hrs 1,096 Hrs 14,698 Hrs

This is data not text. The data is random - not sorted, nor do I want to
sort it. I may or may not have the same company listed more than once in a
worksheet with hours. A company may not even be in a worksheet. What I want
to do is setup a worksheet to summarize by company all of the hours by fiscal
year.
Thanks
BH
 
Top