Sumif question

[Harry Webster]

I have a range of data in column A1 to A10000, which has values ranging from
1 to 500. I want to find the sum of the values which are between 400 and
300.

Any help would be appreciated.

H

 

[Guest]

=SUMPRODUCT(--(A1:A10000>=300),--(A1:A10000<=400),A1:A10000)

 

[Max]

One way
Try:
=SUMIF(A:A,">=300")-SUMIF(A:A,">400")