Calculating the number of observations that fit a range

[seancat]

How do I get Excel to indicate the number of observations that fit within a range of values. For example:

Number of observations in a range (A2:Y2) that are >= 150 but<= 300.

I have tried using =countif(range, criteria)but I can't seem to get the correct criteria statement without getting an error message.

Any suggestions are appreciated.

Seancat
This message was edited by seancat on 2002-11-29 02:23

 

[Aladin Akyurek]

On 2002-11-29 02:14, seancat wrote:
How do I get Excel to indicate the number of observations that fit within a range of values. For example:

Number of observations in a range (A2:Y2) that are >= 150 but<= 300.

I have tried using =countif(range, criteria)but I can't seem to get the correct criteria statement without getting an error message.

Any suggestions are appreciated.

Seancat
This message was edited by seancat on 2002-11-29 02:23

If you mean counting entries between 150 and 300...

Use one of:

=SUM(INDEX(((A2:Y2>=150)*(A2:Y2<=300))+0,1,0))

=SUMPRODUCT((A2:Y2>=150)*(A2:Y2<=300))
This message was edited by aladin akyurek on 2002-11-29 09:28

 

[phantom1975]

WELCOME TO THE BOARD!

Is this what you are looking for?

=ABS(COUNTIF(A2:Y2,">= 150")-COUNTIF(A2:Y2,"<= 300"))