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?

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?

=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?

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?

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

In article ,
knbsmith11 wrote:

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.

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

"JE McGimpsey" wrote:

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

In article ,
knbsmith11 wrote:

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.

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.

In article ,
knbsmith11 wrote:

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

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

"JE McGimpsey" wrote:

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.

In article ,
knbsmith11 wrote:

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