Hi
I need to multiply information in two cells in one column then add it to two multiplied cells in the next column, then repeat for every single column. So at the moment the formula looks something like: =A1*A4+B1*B4+C1*C4+D1*D4+E1*E4, and so on.
Is there a simpler way to do this?
Thanks in advance.
Bookmarks