P
pebbles
A B C D
Employee: Mary
Hire Date: 4/22/2006
Training Topic Hours Next Anniv.
4/16/08 Fish 7.5 4/22/2009
2/1/08 Birds 3
6/10/07 Cats 7.5
5/12/06 Dogs 3
____
Total
How can I SUM column C, only IF the dates in column A fall within a certain
date range? The employee needs to complete 15 hours of ongoing training each
year from anniversary to anniversary. (5/12/06 would not count for this
years total because it started over on 4/22/07.) This person should have 18
hours of current training. I don't want to delete the previous trainings but
I don't want them to show up in the current year total. I tried SUMIF but it
keeps giving me “0â€.
I want to sum the hours in column C if the training dates in column a fall
within the calculated date range. (4/22/08 - 4/22/09)
Employee: Mary
Hire Date: 4/22/2006
Training Topic Hours Next Anniv.
4/16/08 Fish 7.5 4/22/2009
2/1/08 Birds 3
6/10/07 Cats 7.5
5/12/06 Dogs 3
____
Total
How can I SUM column C, only IF the dates in column A fall within a certain
date range? The employee needs to complete 15 hours of ongoing training each
year from anniversary to anniversary. (5/12/06 would not count for this
years total because it started over on 4/22/07.) This person should have 18
hours of current training. I don't want to delete the previous trainings but
I don't want them to show up in the current year total. I tried SUMIF but it
keeps giving me “0â€.
I want to sum the hours in column C if the training dates in column a fall
within the calculated date range. (4/22/08 - 4/22/09)