Thanks:  0
Likes:  0

1. 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)

2. 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)

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

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•