MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Countif the number of entries > x and


Posted by Jamie Riddell on December 14, 2001 1:56 AM

Hello All.

This may seem like an easy question -

I am trying to count the number of times a figure appears in one column (and also the whole worksheet.)

At the moment I can run a =COUNTIF(B10:B73,"<15") Where B10:B73 is my column.

This works for figures less than or greater than.

However, I need to count the number of entries that appear between two values e.g. >15 <30.

Any feedback or advice would be greatly receieved.

Thanks

Jamie


Posted by Aladin Akyurek on December 14, 2001 2:34 AM

Jamie --

It's:

=COUNTIF(B10:B73,">15")-COUNTIF(B10:B73,">=30")

which computes a count according to an exclusive between.

You might want to place x and y values in cells of their own, say, in A1 and A2 (A2>A1).

You can then use:

=COUNTIF(B10:B73,">"&A1)-COUNTIF(B10:B73,">="&A2)

Aladin

=========