Hi Steve

Try the below
=SUMPRODUCT((ISNUMBER(SEARCH("u",B1:B100))*(E1:E10 0=G13)))

If this post helps click Yes
---------------
Jacob Skaria


"Steve" wrote:

I have this formula in columns of cells in 'sheet A'! D column, and the
result is various numbers, e.g. 1 thru 10

=IF(COUNTIF(MasterTab!$BH$21:$BH$917,G13)0,COUNTI F(MasterTab!$BH$21:$BH$917,G13),"")

On the master tab, I also have column B that has various codes in some of
the cells.
And also, on the master tab, in column E, have numbers that may match the
G13 in the above formula.

I need a formula in the A column of sheet A, that has to count the number of
times the letter u shows up in the 'master Tab'!B column when the 'master
tab'!E column matches G13.
If g13 in the above formula =158
So in the below, the result should be 3, which is the first um for 158, the
second um for 158, and the last uc for 158. 3 times the u matches the 158's.

B E

uc 144
um 158

um 158
um 144
uc 158

I hope this makes sense ?

Thanks,

Steve