I would do it like this:
=SUMPRODUCT(--((A26:A31="Approved")),--ISNUMBER(SEARCH("*Lease*",B26:B31)))+SUMPRODUCT(--((A26:A31="Wholesale")),--ISNUMBER(SEARCH("*Lease*",B26:B31)))

HTH,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Don Guillett" wrote:

Where is YOUR effort

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"DSKR" wrote in message
...
I'm having a problem with SumProduct when Column B contains the word
"Lease".
Here's what I want to count: Number of "Lease" IF Column A is "Approved"
or
"Wholesale". I think the problem is the additional information after
"Lease"
in Column B. I've tried using asterisks, but can't seem to find the right
formula. Any ideas?


Column A Column B
Approved M1 Gate/Free/USB/3 Day
Wholesale Pur/A/FS
Approved Lease/Wireless/3-5
Approved Lease/FD 100/3-5
Declined M1 Gate
Approved DP