Hi,

Assuming that you have to bring data from 3 sheets - sheet1, sheet2 and
sheet3, you may use the following formula to sum data in range D4:D8 of each
sheet where the value in range C4:C8 of each sheet is equal to the value
mentioned in cell C4 (ID number) of the summary sheet

SUMPRODUCT(SUMIF(INDIRECT("Sheet"&ROW(INDIRECT("1: 3"))&"!C4:C8"),C4,INDIRECT("Sheet"&ROW(INDIRECT("1 :3"))&"!D4:D8")))

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"sbrodginski" wrote in message
...
I have multiple sheets with 3 columns of data each. The first col is ID
info, the other two track hours and dollars, respectively. I want to add
up
all the numbers in all the sheets in col B(hours) that match each
particular
ID . . . and the IDs do NOT always come in the same rows. I want to do
the
same for the col C(dollars).
My goal is a summary sheet that lists each and every ID with total hours
and
total dollars for each.