ExcelBanter - Sumif question

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Sumif question (https://www.excelbanter.com/excel-worksheet-functions/145889-sumif-question.html)

Harry Webster

Sumif question

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

Teethless mama

Sumif question

=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

Max

Sumif question

One way
Try:
=SUMIF(A:A,"=300")-SUMIF(A:A,"400")
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Harry Webster" wrote in message
...
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

All times are GMT +1. The time now is 10:10 PM.