Kathleen0422
Board Regular
- Joined
- Apr 12, 2006
- Messages
- 188
I am trying to write a formula that will look at the following data:
Column A --> TMID
Column B --> Cost Center
Column C --> TRC Code
Column D --> Name
Column E --> Date Worked
Column F --> Sum of Hours
My logic is:
If Name = Big Kahunna and TRC Code = COMPE or TRC Code = COMPM and Date Worked = 02/24/2009 give me the sum of the Hours
I can't get it to work, can someone help me please.
Thanks,
Column A --> TMID
Column B --> Cost Center
Column C --> TRC Code
Column D --> Name
Column E --> Date Worked
Column F --> Sum of Hours
My logic is:
If Name = Big Kahunna and TRC Code = COMPE or TRC Code = COMPM and Date Worked = 02/24/2009 give me the sum of the Hours
I can't get it to work, can someone help me please.
Thanks,