Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumproduct with condition???
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumproduct with condition???
=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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumproduct with condition???
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumproduct with condition???
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumproduct with condition???
You're welcome, glad it helped.
Jerry neda5 wrote: THANKS That worked perfectly!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If condition is true return sumproduct of two arrays | Excel Worksheet Functions | |||
If condition is true return sumproduct of two arrays | Excel Worksheet Functions | |||
Sumproduct | Excel Worksheet Functions | |||
Sumproduct function not working | Excel Worksheet Functions | |||
adding two sumproduct formulas together | Excel Worksheet Functions |