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


"Harry Webster" wrote:

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