SumIFS Cell

[Shaun]

I am trying to reference a cell in a formula and I would like to say anything
greater then cell J2 but when I input this it searches for text.

=SUMIFS($B$2:$B$27,$A$2:$A$27,"000001",$C$2:$C$27,>D2)
A B C D
1 00001 100 40248 40248
2 12001 150 40237
3 15001 200 40237
4 00001 150 40290
5 00001 50 40350

I would like the total to return 200 because Cell C5 and C4 are larger than
Cell D1 in respect to the Sku number I would like to sum. But when I put in

J2 it enters “>J2†and it won’t return a value other then 0. (If I put in

just D2 then it returns a value of 100 so I know that the formula works I’m
just not sure how to say great or less than in this formula.)

 

[Fred Smith]

The correct syntax is:
=SUMIFS($B$2:$B$27,$A$2:$A$27,"000001",$C$2:$C$27,">"&D2)

Regards,
Fred