Hello, I am trying to perform an equation on 10 columns from left to right. It starts with =((F3/F11)*F12)+((G3/G11)*G12)+((H3/H11)*H12)... and so forth for 10 iterations. Is there any way to accomplish this easier? I played around with offset but I'm not sure if thats what I need, basically the equation is =((X3/X11)*X12 where X starts in column F and ends on column O.
Any help would be greatly appreciated. The way I have it setup now is writing the equation ten times but I figure there is an easier way to do this.
Arek
Bookmarks