not sure how to do a formula
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
|