software

Please Help:

I am trying to do a sumproduct between column B and C for the rows where the
values in column A are under 300 in the table below.
Is there a way to add this condition in the sumproduct formula or do it in
another way?

A B C
100 1,400 5
200 1,800 4
400 1,800 4
150 2,500 4
200 2,500 4
300 3,000 4

Really appreciate it.
NedaHave you tried this?:

Using your sample data:
=SUMPRODUCT(--(A2:A7lt;300),B2:B7,C2:C7)

Does that help?

***********
Regards,
Ronquot;neda5quot; wrote:

gt; Please Help:
gt;
gt; I am trying to do a sumproduct between column B and C for the rows where the
gt; values in column A are under 300 in the table below.
gt; Is there a way to add this condition in the sumproduct formula or do it in
gt; another way?
gt;
gt; A B C
gt; 100 1,400 5
gt; 200 1,800 4
gt; 400 1,800 4
gt; 150 2,500 4
gt; 200 2,500 4
gt; 300 3,000 4
gt;
gt; Really appreciate it.
gt; Neda
gt;

=SUMPRODUCT(--(A1:A6lt;300),B1:B6,C1:C6)

Jerry

neda5 wrote:

gt; Please Help:
gt;
gt; I am trying to do a sumproduct between column B and C for the rows where the
gt; values in column A are under 300 in the table below.
gt; Is there a way to add this condition in the sumproduct formula or do it in
gt; another way?
gt;
gt; A B C
gt; 100 1,400 5
gt; 200 1,800 4
gt; 400 1,800 4
gt; 150 2,500 4
gt; 200 2,500 4
gt; 300 3,000 4
gt;
gt; Really appreciate it.
gt; NedaTHANKS That worked perfectly!!!

quot;Jerry W. Lewisquot; wrote:

gt; =SUMPRODUCT(--(A1:A6lt;300),B1:B6,C1:C6)
gt;
gt; Jerry
gt;
gt; neda5 wrote:
gt;
gt; gt; Please Help:
gt; gt;
gt; gt; I am trying to do a sumproduct between column B and C for the rows where the
gt; gt; values in column A are under 300 in the table below.
gt; gt; Is there a way to add this condition in the sumproduct formula or do it in
gt; gt; another way?
gt; gt;
gt; gt; A B C
gt; gt; 100 1,400 5
gt; gt; 200 1,800 4
gt; gt; 400 1,800 4
gt; gt; 150 2,500 4
gt; gt; 200 2,500 4
gt; gt; 300 3,000 4
gt; gt;
gt; gt; Really appreciate it.
gt; gt; Neda
gt;
gt;

THANKS that worked perfectly!!!

quot;Ron Coderrequot; wrote:

gt; Have you tried this?:
gt;
gt; Using your sample data:
gt; =SUMPRODUCT(--(A2:A7lt;300),B2:B7,C2:C7)
gt;
gt; Does that help?
gt;
gt; ***********
gt; Regards,
gt; Ron
gt;
gt;
gt; quot;neda5quot; wrote:
gt;
gt; gt; Please Help:
gt; gt;
gt; gt; I am trying to do a sumproduct between column B and C for the rows where the
gt; gt; values in column A are under 300 in the table below.
gt; gt; Is there a way to add this condition in the sumproduct formula or do it in
gt; gt; another way?
gt; gt;
gt; gt; A B C
gt; gt; 100 1,400 5
gt; gt; 200 1,800 4
gt; gt; 400 1,800 4
gt; gt; 150 2,500 4
gt; gt; 200 2,500 4
gt; gt; 300 3,000 4
gt; gt;
gt; gt; Really appreciate it.
gt; gt; Neda
gt; gt;

You're welcome, glad it helped.

Jerry

neda5 wrote:

gt; THANKS That worked perfectly!!!