not sure how to do a formula
Try it this way:
=SUMPRODUCT((A1:A25="Pro4")*(LEFT(C1:C25,6)<"Coup on")*(B1:B25*D1:D25))
Hope this helps.
Pete
On Jan 17, 2:34*pm, John wrote:
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- Hide quoted text -
- Show quoted text -
|