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