multiple sheets 2 work books
 

workbook 1 Multiple work sites) collects all data from workbook 2 (time cards
of where individual worked & how many hours (multiple time carsd)
in workbook 1 i was using the sumif to collect the data from #2 and it
worked fine for (1) worksheet. when i tried to add it to all it would not
work due to (3d-reference).
i need a formula to say if workbook 2 sheet1:sheet15"column B2:15" (which is
a drop down of different work sites) equals a certain worksite than multiply
the value in "column c2:15" times X
like i said sumif works great for on worksheet. I can't figure out for
multiple sheets???????
thanks