Forum Discussion
Multiply two rows and add all
The example file you've provided is hard to interpret. It's difficult to understand what you want without a little bit more information. Can you please provide a more complete non-sensitive mock up. The task you require to be completed will be much easier to solve if you are able to provide a more accurate representation of your data.
Surely I will update the file.
The formula has to be in row 1468.
above the formula cell it is date from the 1st of the month till the 31st of the month.
The formula from row 1468 has to first multiply example for the 1st 14I*14C+15I*15C
the cells high light till I reach a certain number then it stops and when it stops I get confused and start to mix up things.
I have to do that formula from 14 to 1467 on the 1st and then when need to make the same formula to the other day where column C price is the same multiplied by the usage of the day and add to the next cell.
I hope you would be able to help me or explain it to me so that I can learn how to do it well.
Thanks in advance for your help and assistance.