Jun 06 2018
10:44 AM
- last edited on
Jul 31 2018
08:22 AM
by
TechCommunityAP
Jun 06 2018
10:44 AM
- last edited on
Jul 31 2018
08:22 AM
by
TechCommunityAP
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)+(W29*$W$7)+(X29*$X$7)+(Y29*$Y$7)+(Z29*$Z$7)........
Jun 06 2018 10:50 AM
SolutionHi Lee,
Could be
=SUMPRODUCT($M$7:$Z$7,M29:Z29)
Jun 06 2018 10:50 AM
Solution