I am having difficulties with coming up with a correct formula. I need a formula that says to sum F12:F106 with the following two criterias.
1. criteria range of C12:C106 and criteria 36
2. criteria range of D12:D106 criteria of date is greater than 12/31/2012 and less than 1/1/2014
I am doing fine all the way up through the first criteria. The date formula is what is giving me fits.