SumIFS Cell
 

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 wont 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 Im
just not sure how to say great or less than in this formula.)

SumIFS Cell
 

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

Regards,
Fred

"Shaun" wrote in message
...
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.

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 wont 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 Im
just not sure how to say great or less than in this formula.)