Try

=SUMPRODUCT((AL29:AL46=O77)*(AN29:AN46=F74)*(ISNUM BER(SEARCH(F74,AN29:AN46))))

--
__________________________________
HTH

Bob

"Monte" wrote in message
...
I am counting the number of services done by using two letter abreviations,
TN CL PS MV BK RF, Referenced as F74 F75 F76 F77 F78 F79 respectively
I have this formula that works well with a single reference (F74).
=SUMPRODUCT((AL29:AL46=O77)*(AN29:AN46=F74)*(AN29: AN46=F74)).
I type TN in the cell in the array AN29:AN46 and the other two qualifiers
logic true and it directs the answer to be 1 and so on down the column.
I need it to identify a single reference from within multiple references
within a single cell, where (AN29:AN46) could be any or all of the
abbreviations in one cell and still have it identify only one.

=SUMPRODUCT((AL29:AL46=O77)*(AN29:AN46=F74)*(AN29: AN46=F74)).

AL29 AN29
RM TN BK PS
RM TN MV
RM RF

Looking forward to your assistance



--
Daily Tracker