Conditional Statement for specific values

[jpiscit1]

I am looking to write a statement that counts how many number fall between a giving set of criteria. For example:

Greater than 300 but less than 350.
COUNT = x

Can anyone help?

 

[PaddyD]

On 2002-11-04 15:00, jpiscit1 wrote:
I am looking to write a statement that counts how many number fall between a giving set of criteria. For example:

Greater than 300 but less than 350.
COUNT = x

Can anyone help?

Hi - welcome to the board!

one of many options:

=sumproduct((range>300)*(range<350))

see
http://mrexcel.com/board/viewtopic.php?topic=20900&forum=2

for more info (follow the link to Aladin's post)

paddy

 

[Aladin Akyurek]

On 2002-11-04 15:00, jpiscit1 wrote:
I am looking to write a statement that counts how many number fall between a giving set of criteria. For example:

Greater than 300 but less than 350.
COUNT = x

Can anyone help?

=COUNTIF($A$2:$A$100,">"&E1)-COUNTIF($A$2:$A$100,">="&F1)

where A2:A100 houses the data of interest, E1 a value like 300, and F1 a value like 350, always with E1 < F1.

 

[jpiscit1]

Thanks. This was very helpful!

John