# How to check if a number is present in a range of cells?

1. ## How to check if a number is present in a range of cells?

Hi,

I have 3 random integers between 1 to 10 in A2:C2 and also integers from to 1 to 8 in D1:K1 as shown below in example.

Now I want to count the number cells in the range of D2:K2 such that value is greater than 20 and also number above in the same column should NOT present in A2:C2.

To explain clearly, below I have tried to recreate part of worksheet and result of this example will be 2. So I have considered just cells D2 and J2 but not G2 as value of G1 is 4 which is present in A2:C2. Please refer to the attache snapshot of worksheet to understand more clearly.

A B C D E F G H I J K L M N O P R S T U V
1 1 2 3 4 5 6 7 8
2 3 4 6 21 15 17 23 12 16 22 11
3
4

2. ## Re: How to check if a number is present in a range of cells?

attach a sample file, not png

3. ## Re: How to check if a number is present in a range of cells?

Hi everybody.

4. ## Re: How to check if a number is present in a range of cells?

Hi..

Please find the attached sheet. In this sheet I want to count the numbers of nodes (special nodees excluded) which has throughput more than 20.

Special nodes for each case is given in coulmns A to C and Throughput per node is given in column D to K.

Manually calculated result is given in column L.

Thanks again..

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1