Forum Discussion

Lee McKinney's avatar
Lee McKinney
Copper Contributor
Jun 06, 2018
Solved

Help with a fomula

Need a formula to add (sum) a series of other calculations with a certain range. EX:  =(M29*$M$7)+(N29*$N$7)+(O29*$O$7)+(P29*$P$7)+(Q29*$Q$7)+(R29*$R$7)+(S29*$S$7)+(T29*$T$7)+(U29*$U$7)+(V29*$V$7)+(...
  • SergeiBaklan's avatar
    Jun 06, 2018

    Hi Lee,

     

    Could be

    =SUMPRODUCT($M$7:$Z$7,M29:Z29)

Resources