IF formula? Maybe a Pivot table instead?

[kgowett]

I have just a standard perpetual calendar Excel template. I need something to essentially scan the cells, and if a certain name is in a cell, add the corresponding number into a different location.

So....

March 1st has Agent A taking 8 hours off work.
Agent A's name is F17, Agent A's time is in F16.
Anywhere Agent A's name appears, it will have a value that corresponds. If there's no value, that means they did not take time off, therefore their name is not entered. Is there a way to calculate the sum of hours in corresponding cells for Agent A?
This will also need to be repeated for Agent B, Agent C, so on for 9 different agents.
Also, this will have to be duplicated on each tab that holds a different month, and hopefully I can easilly make something to total all of the information onto a new sheet at the end of the workbook. That new tab will calculate Year to Date time off work. *HOPEFULLY* !!

Could this be done via a pivot table? If so, how?!

[Pete_UK]

Take a look at this thread:

http://www.excelforum.com/excel-form...e-to-tab2.html

My attachment displays a Vacation calendar and provides some statistics automatically.

Hope this helps.

Pete