Tricky COUNTIF Question

gyerkes · Mar 27th, 2002, 05:33 PM

Hi, I am having a problem using COUNTIF to count using a range of numbers in 2 different cells. For example, in c7 I have 24 and in c8 have 26 and I want to count the number of clients that we have that produced revenue >=c7 AND <=C8. It is difficult because COUNTIF will not let you use <> to reference a given cell. any clue on how TO DO THIS? Below is the formula I am currently using to reference one cell and it works fine. I just want to add a >c7 and <=c8 in place of the C7.

=COUNTIF(Sheet1!$B$4:$B$1846,C7)

Aladin Akyurek · Mar 27th, 2002, 05:36 PM

Quote:

On 2002-03-27 16:33, gyerkes wrote:
Hi, I am having a problem using COUNTIF to count using a range of numbers in 2 different cells. For example, in c7 I have 24 and in c8 have 26 and I want to count the number of clients that we have that produced revenue >=c7 AND <=C8. It is difficult because COUNTIF will not let you use <> to reference a given cell. any clue on how TO DO THIS? Below is the formula I am currently using to reference one cell and it works fine. I just want to add a >c7 and <=c8 in place of the C7.

=COUNTIF(Sheet1!$B$4:$B$1846,C7)

Try:

=COUNTIF(Sheet1!$B$4:$B$1846,">"&C7)-COUNTIF(Sheet1!$B$4:$B$1846,">"&C8)

gyerkes · Mar 27th, 2002, 05:52 PM

Aladin, you are the man!! Thanks a lot!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 27th, 2002, 05:33 PM	#1
gyerkes New Member Join Date: Mar 2002 Posts: 2	Hi, I am having a problem using COUNTIF to count using a range of numbers in 2 different cells. For example, in c7 I have 24 and in c8 have 26 and I want to count the number of clients that we have that produced revenue >=c7 AND <=C8. It is difficult because COUNTIF will not let you use <> to reference a given cell. any clue on how TO DO THIS? Below is the formula I am currently using to reference one cell and it works fine. I just want to add a >c7 and <=c8 in place of the C7. =COUNTIF(Sheet1!$B$4:$B$1846,C7)

Mar 27th, 2002, 05:52 PM	#3
gyerkes New Member Join Date: Mar 2002 Posts: 2	Aladin, you are the man!! Thanks a lot!