On May 5, 4:43*pm, pebbles wrote:
* * * * 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)

You can create another column which takes Anniversary date - Training
Date. This will give you the number of days between the two dates,
then you can use the Sumif function. =sumif(columns where data
Annivesary Date- training date is held, "<366",column where training
hours is held)
i.e. =SUMIF(E31:E34,"<366",C31:C34)


There may be a way to do the comparison in the sumif statement itself,
but I don't know.