Conditional Statement Question
=SUMPRODUCT((A1:A4501="AG")*(B1:B4501)*(C1:C4501))
Hans
"knbsmith11" skrev i en meddelelse ...
I need a formula for the following synario:
Column A = either AG, AP or WW
Column B = %
Column C = Amount
and I have 4500 rows of data below
What I want to do is say if column A = AG, than multiply column B by Column
C and add up all the rows that meet the criteria and put them in this cell.
Can anyone help?
|