SUMIF returns 0 when comparing a date

[mathiasav]

Hi,

This might be a stupid question but I'm not an expert (yet) in Excel formulas.

I have used the following formula:
=SUMIF(A:A,A:A<TODAY(),B:B)

In my column A, I have only dates and in my column B numbers.
I tried a simple IF to compare A with TODAY() and this works perfectly. I have also made a SUM of B apart.
So, why it doesn't work when using a SUMIF ???

Thanks.

 

[wideboydixon]

=SUMIF(A:A,"<"&TODAY(),B:B)

WBD