Hi everyone,
I don't get to work with functions in Excel very often and I know there are plenty out there to accomplish whatever you need - the trick is finding the right one!!
Below is the spreadsheet I am creating. What I'm trying to do is have a function in C4, C5, & C6 that will look at the cells that match the corresponding text under Abscence Reason and then sum the hours in the cell to the right in column F.
For example, C4 should see there is only 1 Personal day being used and then return a result of 4 hours. C5 should see 3 Vacation days being used, add up the corresponding values and return 20. C6 for Sick days should return 8.
I have a feeling that I should be using a combination of a AND, IF, and one of the counting functions, but I'm not real sure how to do it.
Thanks for your help!
-- Jim
I don't get to work with functions in Excel very often and I know there are plenty out there to accomplish whatever you need - the trick is finding the right one!!
Below is the spreadsheet I am creating. What I'm trying to do is have a function in C4, C5, & C6 that will look at the cells that match the corresponding text under Abscence Reason and then sum the hours in the cell to the right in column F.
For example, C4 should see there is only 1 Personal day being used and then return a result of 4 hours. C5 should see 3 Vacation days being used, add up the corresponding values and return 20. C6 for Sick days should return 8.
I have a feeling that I should be using a combination of a AND, IF, and one of the counting functions, but I'm not real sure how to do it.
Thanks for your help!
-- Jim
| BPI Attendance Report.xls | |||||||||
|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | |||
| 1 | Attendance Year Ending: | ||||||||
| 2 | |||||||||
| 3 | Type | Allowed | Taken | Scheduled | Remaining | ||||
| 4 | Personal | 40.00 | 1.00 | 39.00 | |||||
| 5 | Sick | 40.00 | 1.00 | 39.00 | |||||
| 6 | Vacation | 80.00 | 3.00 | 77.00 | |||||
| 7 | |||||||||
| 8 | Date | Absence Reason | Hours | Paid/Unpaid | |||||
| 9 | Tuesday, January 06, 2004 | Personal | 4.00 | ||||||
| 10 | Wednesday, May 12, 2004 | Vacation | 4.00 | ||||||
| 11 | Thursday, May 13, 2004 | Vacation | 8.00 | ||||||
| 12 | Friday, May 14, 2004 | Vacation | 8.00 | ||||||
| 13 | Saturday, May 15, 2004 | Sick | 8.00 | ||||||
| 14 | |||||||||
Template | |||||||||
