This one works best for the functionality.
It allows any length of text which if the operator hits an extra keystroke
would throw off my other criteria of 6 positions.
Thanks!
--
Thank you for your time.
Windows XP
Office 2002


"Teethless mama" wrote:

=SUMPRODUCT(--(ISNUMBER(SEARCH("OP",'Jan-'!H2:H65536))),'Jan-'!C2:C65536)


"James Kendall" wrote:

I am trying to find OP in the list of cells. It works if it is the only
words in the cell but I need it to work if there is more than just "OP".
Suggestions?

=SUMPRODUCT(--(MID('Jan-'!H2:H65536,1,6)="OP"),+('Jan-'!C2:C65536))
--
Thank you for your time.
Windows XP
Office 2002