Sumproduct with condition???

[neda5]

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

 

[Ron Coderre]

Have you tried this?:

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

Does that help?

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

 

[Jerry W. Lewis]

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

Jerry

 

[neda5]

THANKS That worked perfectly!!!

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

Jerry

 

[neda5]

THANKS that worked perfectly!!!

Have you tried this?:

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

Does that help?

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

 

[Jerry W. Lewis]

You're welcome, glad it helped.

Jerry