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.



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

Jamie --



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: