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

**neelabh_krishna** · 10-05-2012, 12:58 PM

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

Thanks in advance...

**patel45** · 10-06-2012, 12:12 AM

attach a sample file, not png

**raveendra.k** · 10-06-2012, 12:46 AM

Hi everybody.

**neelabh_krishna** · 10-07-2012, 04:22 AM

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