Please tell me what I did wrong with SUMIFS statment

[Dark0Prince]

it works until I tried doing less then or equal to J2

=SUMPRODUCT(SUMIFS(ABQSTATS!E:E,ABQSTATS!A:A,ABBYABQ,ABQSTATS!B:B,'SEPTEMBER 2018'!$I$2,ABQSTATS!C:C,"<="&$J$2))

 

[GJSBED]

it works until I tried doing less then or equal to J2

=SUMPRODUCT(SUMIFS(ABQSTATS!E:E,ABQSTATS!A:A,ABBYABQ,ABQSTATS!B:B,'SEPTEMBER 2018'!$I$2,ABQSTATS!C:C,"<="&$J$2))

Do we need the " "& around the <= ????
Is it no just <= $J$2 ??

 

[Dark0Prince]

It will through an error if I don't have the quotes and try to write it like that: <= $J$2

 

[steve the fish]

Looks fine to me. Why do you think it isnt?

 

[Dark0Prince]

The result is 0 and j2 has the number 21 in there so anything less then or equal to 21 in the C column should show up.

 

[Dark0Prince]

=SUMPRODUCT(SUMIFS(GJSTATS!E:E,GJSTATS!C:C,"<="&$J$2))

Even this by itself gives 0 data and I have many numbers in E that should be sumed up when less then 21 or (J2)

And this works, which i don't need

,"<>"&J2

 

[steve the fish]

I think the column E of GJSTATS contains textual numbers not real numbers so excel doesnt sum them.

 

[Dark0Prince]

Thanks you were right.