Find and count (sumproduct)
Great! This work also!
I like it because it is shorter.
Thanks!
--
Thank you for your time.
Windows XP
Office 2002
"Mike H" wrote:
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
|