the coupon is being calculated in the formula, isn't there a wildcard that
can be put in to say don't include anything that starts with coupon?

"Mike H" wrote:


maybe this

=SUMPRODUCT((A1:A25="Pro4")*(C1:C25<"Coupon")*(B1 :B25*D1:D25))

Mike

On Jan 16, 8:59 pm, John wrote:
I have a 4 dynamic columns of data that connects to an access database.

Code Counts Description Quantity
pro1 2 1
pro2 1 1
pro3 1 1
pro4 4 1
pro4 1 2
pro5 1 1
pro4 2 Coupon:34 1

What I need to do is evaluate Column A(code) to see if it matches "pro4" if
yes than multipy column b(counts) to column e(quantity) then add up pro4
which in this case would equal 6(without the one that says coupon).

Thanks in advance