OK this is the formula I need, but I know there must be an easier way. I have 100 rows that I will copy this down to.. BUT i have columns all the way to UU .. it is a going to take me forever to just set it up.. any suggestions? The fixed price is obviously in the row #1... but i need to be able to add each column together then do this for each client. I know there has to be an easier way I just can't figure it out..
=(M3*$M$1)+(N3*$N$1)+(O3*$O$1)+(P3*$P$1)+(Q3*$Q$1)+(R3*$R$1) ....... all the way though column + (U3*$UU$1)
Thank you in advance for any help I can get...
Bookmarks