multiple sheets 2 work books

C

capt c

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top