counts repeated number in two seperate area

[sierra spiegel]

I have a formula:
IF(COUNTIF(A2:C6,A1)

The problem is that i need to search in two areas. The above formula only search the whole area without breaking an area.

For example to what I want:

A1 4 6 8 9 10
A2 5 6 23 44 50
A3 4 7 8 9 22
A4 7 3 1 2 8

I want to search row A2 and A4 only to see if any number matches with any number in A1.

Thank you very much!!!!

EggHeadCafe - Software Developer Portal of Choice
Generic GetXmlReader Data Access Method
http://www.eggheadcafe.com/tutorial...d-b6ebb3575e5e/generic-getxmlreader-data.aspx

 

[T. Valko]

IF(COUNTIF(A2:C6,A1)

I want to search row A2 and A4

A2 and A4 are not rows, they're individual cells.

Based on the above formula maybe this is what you want:

=COUNTIF(A2:C2,A1)+COUNTIF(A4:C4,A1)