Excel Question

[alish]

All,

I need your help: Please see below:
line1: 1
line2: 1
line3: 1
line4: 2

result: 2

I want the result to show if the any lines (cells) of the above cells
contain 2, if not nothing.

Thanks in advance.

 

[Gav123]

Hi,

You could use COUTNIF

Assume your numbers (1 & 2) are in range B2:B10 in B11 enter
=COUNTIF(B2:B10,"2")

Hope this helps,

Gav.

 

[tedmi]

That will return the COUNT of rows containing 2's. If you want to display the
number 2 if ANY row in the range contains a 2, do this:

=IF(COUNTIF(B1:B10,2)>0,2,"")

 

[alish]

Thank you Gav and Tedmi. It worked.