SUMPRODUCT with Multiple Criteria Returns Wrong Value

[Agimcomas]

I am using a SUMPRODUCT(--,(... formula that looks like this:

=SUMPRODUCT(--(Sheet1!A6:A19<=Données!$C$5),--(Sheet1!C6:C19=Données!$L32),--(Sheet1!G6:G19))

It returns the value 0.00. But it is wrong! It's driving me crazy. I appreciate your help!

[daddylonglegs]

Your formula looks OK except you probably don't need to "co-erce" the sum range, i.e. this should be sufficient

=SUMPRODUCT(--(Sheet1!A6:A19<=Données!$C$5),--(Sheet1!C6:C19=Données!$L32),Sheet1!G6:G19)

I assume there are numbers in column G, what sort of values are in A6:A19 and C6:C19?

[Agimcomas]

Thanks for your attention. The two criteria ranges contain dates in yyyy-mm and yyyy-mm-dd form such as 201012 and 20101031.

Still doesn't work, and I know the formula is right. For now I recorded a macro to deal with the problem, but I'd like to avoid macros.

Thanks!

[Haseeb Avarakkan]

Can you please attach a dummy file?