Sumproduct with condition???

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.
Neda

Have you tried this?:

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

Does that help?

***********
Regards,
Ron


"neda5" wrote:

> 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.
> Neda
>

=SUMPRODUCT(--(A1:A6<300),B1:B6,C1:C6)

Jerry

neda5 wrote:

> 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.
> Neda

THANKS That worked perfectly!!!

"Jerry W. Lewis" wrote:

> =SUMPRODUCT(--(A1:A6<300),B1:B6,C1:C6)
>
> Jerry
>
> neda5 wrote:
>
> > 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.
> > Neda
>
>

THANKS that worked perfectly!!!

"Ron Coderre" wrote:

> Have you tried this?:
>
> Using your sample data:
> =SUMPRODUCT(--(A2:A7<300),B2:B7,C2:C7)
>
> Does that help?
>
> ***********
> Regards,
> Ron
>
>
> "neda5" wrote:
>
> > 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.
> > Neda
> >

You're welcome, glad it helped.

Jerry

neda5 wrote:

> THANKS That worked perfectly!!!