Code:
=SUMPRODUCT(--(B13:B15="ABC"),C13:C15,--(E13:E15="ABC"),F13:F15,--(H13:H15="ABC"),I13:I15)
ABC | 400.00 | E | 300.0 | E | 300.0 | ||
A | 450.00 | A | 600.0 | A | 600.0 | ||
ABC | 0.89 | ABC | 0.50 | ABC | 0.50 |
<tbody>
</tbody>
Hello Everyone
- I have the above formula and the above data.
- The data is in the range of: B13:I15 with two blank columns in between.
- The first ABC (top left) is in cell B13 and the 400 next to it is in cell C13.
- The last ABC (bottom right) is in cell H15 and the .5 next to it is in cell I15
My formula above is giving me an answer of .22 (.89*.5*.5)
What I'm trying to get, is the sum of all the ABC's (400+.89+.5+.5)=401.89
So I'm not having any luck with getting 401.89
Can someone help me please
Thanks for the help
Last edited: