Hello,
What I am trying to do is hard to explain, but an example will help:
I am trying to multiply two cells together that are in the same row, then add that product to the product of the same cells just in the row below it
. AB
1 20 .10
2 40 .25
3 10 .5
_______________________
4 Total X
I have attached another example with the highlighted portion being the total line, also the data set that I am trying to run this on has multiple columns and rows so it is not possible to add in a column to the left and add the sums
All help is appreciated,
Regards
Bookmarks