- 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