I am trying to find the cleanest way to sum the numbers in a column, but only if the corresponding row value in another column is found within a current table. Below is what I am working with.
I need to add up the subtotal column only if the value in the corresponding item column is found within a table "ListPrice". In this example, the first line item "W2430" would be in the table, while the second line item "man-pfg" would not be in the table.
<colgroup><col span="3"><col span="3"></colgroup><tbody>
</tbody>
I was thinking about using SumProducts, but could not get what I needed to working. Any ideas?
I need to add up the subtotal column only if the value in the corresponding item column is found within a table "ListPrice". In this example, the first line item "W2430" would be in the table, while the second line item "man-pfg" would not be in the table.
Item | List Price | Multiplier Price | Subtotal |
w2430 | $ 400.00 | $ 112.00 | $ 112.00 |
man-pfg | $ 35.00 | $ 35.00 | $ 70.00 |
<colgroup><col span="3"><col span="3"></colgroup><tbody>
</tbody>
I was thinking about using SumProducts, but could not get what I needed to working. Any ideas?