P
pebbles
Employee: Mary
Hire Date: 4/22/2006
A B C D E
Training Date Current Hours: By Next Anniv.
4/16/08 7.5 4/22/2009
2/1/08 3
6/10/07 7.5
5/12/06 3
Total
How can I SUM column C, only IF the dates in column A are current?
Trainings are good for one year, from one anniversary of hire date to the
next. (5/12/06 would not count for this years training.) This person should
have 18 hours of current training. I don't want to delete the out of date
training though. I tried SUMIF but it keeps giving me 0. This is how I
tried it. (Don't laugh, I'm learning.)
=SUMIF(A4:A11,"($E$4)-365>",C4:C11)
Hire Date: 4/22/2006
A B C D E
Training Date Current Hours: By Next Anniv.
4/16/08 7.5 4/22/2009
2/1/08 3
6/10/07 7.5
5/12/06 3
Total
How can I SUM column C, only IF the dates in column A are current?
Trainings are good for one year, from one anniversary of hire date to the
next. (5/12/06 would not count for this years training.) This person should
have 18 hours of current training. I don't want to delete the out of date
training though. I tried SUMIF but it keeps giving me 0. This is how I
tried it. (Don't laugh, I'm learning.)
=SUMIF(A4:A11,"($E$4)-365>",C4:C11)