Try...
=SUMIF(A1:A100,"=1",B1:B100)-SUMIF(A1:A100,"10",B1:B100)
Hope this helps!
In article ,
"jiwolf" wrote:
I am looking to sumif the value in a cell is between 1 and 10. I am ok
with values above 10,
=SUMIF(A1:A100,"10",B1:B100) but I cant get above a certain value and
below another! any help please?
Pete
|