Sumifs and using >=

[sleepingtiger]

I am trying to use multiple conditions to find the sum of the invoice that meet the conditions. One of the condition is sum if Date A is greater than Date B.

=SUMIFS(Data!$N$2:$N$47638,Data!$C$2:$C$47638,Sheet1!$A3,Data!$F$2:$F$47638,Sheet1!$C2,Data!$A$2:$A$47638,">="&$B3)

Data!$A$2:$A$47638 refers to a set of dates and $B3 refers to the cutoff date. I can't see to get it too work.

Should I convert the date to a number format first than try it?

 

[steve the fish]

What do you mean by not working? Formatting wont make any difference. Formatting doesnt change a cell value only what it looks like.

 

[sleepingtiger]

im a moron, the condition was correct. It was another condition that was incorrect. I locked the wrong cell? Sorry folks