I am trying to do a simple sumif, but the formula always gives me zero.
I need to sum numbers in column F if the dates in column A are within a certain range. I would like this range to come from dates in cells on another worksheet. If I hand type the dates, the numbers populate correctly, but if I select the cell with the dates in my formula if will not calculate and gives zero for the answer. It seems to be from the >,< signs because if I am going for an exact match it will calculate.
In the formula A2 is my low date and A3 is the high date for the range.
=SUMIF('GFRC Schedule'!A3:A136,">A2",'GFRC Schedule'!F3:F218)-SUMIF('GFRC Schedule'!A3:A136,">=A3",'GFRC Schedule'!F3:F218)
I need to sum numbers in column F if the dates in column A are within a certain range. I would like this range to come from dates in cells on another worksheet. If I hand type the dates, the numbers populate correctly, but if I select the cell with the dates in my formula if will not calculate and gives zero for the answer. It seems to be from the >,< signs because if I am going for an exact match it will calculate.
In the formula A2 is my low date and A3 is the high date for the range.
=SUMIF('GFRC Schedule'!A3:A136,">A2",'GFRC Schedule'!F3:F218)-SUMIF('GFRC Schedule'!A3:A136,">=A3",'GFRC Schedule'!F3:F218)