Conditional Statement Question

[Guest]

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?

 

[JE McGimpsey]

one way:

=SUMPRODUCT(--(A1:A4500="AG"),B1:B4500,C1:C4500)

 

[Hans Knudsen]

=SUMPRODUCT((A1:A4501="AG")*(B1:B4501)*(C1:C4501))

Hans

 

[Guest]

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]

Did you actually try it? Or just decide it doesn't work?

 

[Guest]

I tried it, and it gave me the wrong answer.

Did you actually try it? Or just decide it doesn't work?

 

[JE McGimpsey]

Then you need to look at your data. Perhaps you have leading or trailing
spaces in column A, or perhaps some of your numbers entered as Text.

To check the latter, try copying a blank cell, selecting your numbers,
then choosing Edit/Paste Special, selecting the Values and Add radio
buttons. This will coerce any text values to numeric.

 

[Guest]

JE, thanks so much. You were correct, I had something in my formula wrong.
It works great now!!