Conditional Statement Question
Thanks for the input, however its a little more complicated than that. I
actually need to multiply columns B & C in each row then add all the them.
So more like b1*c1 + b2*c2 +b3*c3 but for 4500 rows and if they all meet the
condition of A=AG.
"JE McGimpsey" wrote:
one way:
=SUMPRODUCT(--(A1:A4500="AG"),B1:B4500,C1:C4500)
In article ,
knbsmith11 wrote:
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?
|