IF contains over multiple worksheets

T

Teri

This may be difficult to put into words, but I'm sure going to try!

I have two spreadsheets: one with Compensation Information and the other is
an Attendance spreadsheet.

I want the spreadsheet with Compensation information to calculate total Paid
Vacation based on the following criteria:

IF Cell C3 in Attendance - 2004.xls contains the same data as Cell C3 in
Total Comp Report.xls, then I want it to calculate Attendance - 2004.xls Cell
H6* Total Comp Report.xls Cell H2.

Is this remotely possible?
 

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

Similar Threads

Calc staff vacation time based on more than 1 criteria 0
Interest Calculations 6
Help needed with a formula or macro 1
The sum of data based on words 3
Calculate total metric based on sum of metric over specific time f 1
Help: vlookup from multiple sheets and spreadhseets 1
SUMPRODUCT, SUMIF, COUNTIF for multiple sheets for multiple criter 0
Summing over multiple worksheets 1

Top