| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
IF contains over multiple worksheets
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What is the quickest method to insert & name multiple worksheets . | Excel Worksheet Functions | |||
| adding certain cells in multiple worksheets in multiple workbooks | Excel Worksheet Functions | |||
| Countif with multiple criteria and multiple worksheets | Excel Worksheet Functions | |||
| Multiple Worksheets and Print Merge function | Excel Discussion (Misc queries) | |||
| copy pivot table to multiple worksheets | Excel Worksheet Functions | |||
Linear Mode
