Forum Discussion

Carlos_cie's avatar
Carlos_cie
Copper Contributor
Jan 13, 2023

Count If

Hi Everyone, 

 

I have this column with 6000 register of diferente number  ( A) 

Net 
9,911,076.33
8,177,140.33
9,044,108.33
9,911,076.33
8,032,645.67
9,766,581.67
9,477,592.33
9,622,087.00

 

And in the other side other number ( B) 

8,842,670.19
8,930,221.38
9,017,772.57
9,105,323.76
9,192,874.95
9,280,426.14
9,367,977.33

 

I want to calculate the possibility of the B kind of number would be include in the A 

 

I tried with  =

Countif ( A1:A6000, "B1") But i cant 

Lookup( B1, A1:A6000, >B1") 

And more ...

ANybody can help me ???

Thanks inn advaced

 

office 365

1 Reply

  • OliverScheurich's avatar
    OliverScheurich
    Gold Contributor
    Jan 13, 2023

    Hello Carlos_cie ,

    in the screenshot is a simplified example of your data. Let's say that in ( A) there are all numbers from 1 to 6000 and in ( B) there are numbers 2, 9, 105, 200 and 1150. Can you communicate the expected results for the numbers in ( B)?

Resources