software

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=quot;AGquot;),B1:B4500,C1:C4500)

In article gt;,
knbsmith11 gt; wrote:

gt; I need a formula for the following synario:
gt;
gt; Column A = either AG, AP or WW
gt; Column B = %
gt; Column C = Amount
gt; and I have 4500 rows of data below
gt;
gt; What I want to do is say if column A = AG, than multiply column B by Column
gt; C and add up all the rows that meet the criteria and put them in this cell.
gt;
gt; Can anyone help?

=SUMPRODUCT((A1:A4501=quot;AGquot;)*(B1:B4501)*(C1:C4501))

Hansquot;knbsmith11quot; gt; skrev i en meddelelse ...
gt;I need a formula for the following synario:
gt;
gt; Column A = either AG, AP or WW
gt; Column B = %
gt; Column C = Amount
gt; and I have 4500 rows of data below
gt;
gt; What I want to do is say if column A = AG, than multiply column B by Column
gt; C and add up all the rows that meet the criteria and put them in this cell.
gt;
gt; Can anyone help?
Thanks for the input, however its a little more complicated than that. I
actually need to multiply columns B amp; 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.

quot;JE McGimpseyquot; wrote:

gt; one way:
gt;
gt; =SUMPRODUCT(--(A1:A4500=quot;AGquot;),B1:B4500,C1:C4500)
gt;
gt; In article gt;,
gt; knbsmith11 gt; wrote:
gt;
gt; gt; I need a formula for the following synario:
gt; gt;
gt; gt; Column A = either AG, AP or WW
gt; gt; Column B = %
gt; gt; Column C = Amount
gt; gt; and I have 4500 rows of data below
gt; gt;
gt; gt; What I want to do is say if column A = AG, than multiply column B by Column
gt; gt; C and add up all the rows that meet the criteria and put them in this cell.
gt; gt;
gt; gt; Can anyone help?
gt;

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

In article gt;,
knbsmith11 gt; wrote:

gt; Thanks for the input, however its a little more complicated than that. I
gt; actually need to multiply columns B amp; C in each row then add all the them.
gt; So more like b1*c1 b2*c2 b3*c3 but for 4500 rows and if they all meet the
gt; condition of A=AG.

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

quot;JE McGimpseyquot; wrote:

gt; Did you actually try it? Or just decide it doesn't work?
gt;
gt; In article gt;,
gt; knbsmith11 gt; wrote:
gt;
gt; gt; Thanks for the input, however its a little more complicated than that. I
gt; gt; actually need to multiply columns B amp; C in each row then add all the them.
gt; gt; So more like b1*c1 b2*c2 b3*c3 but for 4500 rows and if they all meet the
gt; gt; condition of A=AG.
gt;

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 gt;,
knbsmith11 gt; wrote:

gt; 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!!

quot;JE McGimpseyquot; wrote:

gt; Then you need to look at your data. Perhaps you have leading or trailing
gt; spaces in column A, or perhaps some of your numbers entered as Text.
gt;
gt; To check the latter, try copying a blank cell, selecting your numbers,
gt; then choosing Edit/Paste Special, selecting the Values and Add radio
gt; buttons. This will coerce any text values to numeric.
gt;
gt; In article gt;,
gt; knbsmith11 gt; wrote:
gt;
gt; gt; I tried it, and it gave me the wrong answer.
gt;