On Tuesday, February 18, 2014 6:10:42 AM UTC-8, Claus Busch wrote:
Hi Howard,



Am Tue, 18 Feb 2014 04:40:08 -0800 (PST) schrieb L. Howard:



Sheet 2 cell A4 = 456 (a true number)



Sheet 1 Cells C12:M16 contain blank cells and cell values like:



P 456 J Smith

A 123 A Monk

P 789 I Seek

P 456 J Smith



if "P" is in column C and the numbers are in column D then try:



=COUNTIFS(Sheet1!$D$12:$D$200,A4,Sheet1!$C$12:$C$2 00,"P")

or

=SUMPRODUCT(--(Sheet1!$D$12:$D$200=A4),--(Sheet1!$C$12:$C$200="P"))







Regards

Claus B.

--

Hi Claus,

After seeing you response, I now see how misleading my query is.

This "P 456 J Smith" and the others like it are all in a cell to themselves.

So my little mini example would be four cells with in the C12:M16 range.

Hence my thought of needing the wild card trick and the need to compare a real number with a number as text.

Howard

Howard