I have column A with date values formatted as mm/dd/yyyy
. I am trying to sum the values of column B if A >=DATE(2012,1,1) AND
=SUM(B:B)
sums B properly, but if I try to use =SUMIF(B:B,A:A>=DATE(2012,1,1))
the value returned is 0.00
. I'm assuming this has something to do with using decimal for the sum and date type for the criteria. Is there a way to get around this?
Thanks
You haven't got your SUMIF
in the correct order - it needs to be range, criteria, sum range. Try:
=SUMIF(A:A,">="&DATE(2012,1,1),B:B)