Excel Question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

alish - 10 Apr 2008 12:24 GMT

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.

Reply to this Message

Gav123 - 10 Apr 2008 12:48 GMT

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.

> All,
>
[quoted text clipped - 10 lines]
>
> Thanks in advance.

Reply to this Message

tedmi - 10 Apr 2008 13:37 GMT

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,"")

Signature

TedMi

Reply to this Message

alish - 10 Apr 2008 17:50 GMT

Thank you Gav and Tedmi. It worked.

> All,
>
[quoted text clipped - 10 lines]
>
> Thanks in advance.

Reply to this Message