sorry forgot the reference to another sheet

=SUMIF('Jan-'!H2:H65536,"*OP*",'Jan-'!C2:C65536)


Mike

"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