Adding Multi-part Formula

[PhilosophersSage]

I have several hundred formulas that sum up a portion of work with a
multi-part formula:
=(H61+J61)&" of "&(A60*2)&" Connections for
"&ROUND((H61+J61)/(A60*2)*100,2)&"% Hook-up Complete"
which gives me "# of #'s Connections for % Hook-up Complete".

Is there a way to add all the # of #'s together to get a total without going
through and adding every cell together?

 

[David Biddulph]

=SUM(H61:H961,J61:J961)
=2*SUM(A60:A960)

Adjust the ranges as appropriate.

 

[JP]

Can you use the SUM formula? Or how about naming the range, then just
write =Sum(RangeName) to get the total?

--JP

 

[PhilosophersSage]

I which it was that simple but that will not work as there is other data in
the range, even if I just used the sum function I would have over 800
arguments. As I inherited this worksheet the formatting cannot change the
layout (it is contractually agreed) so that it is more function friendly.
Also the number of lines between the summation lines are varied so I cannot
add every X row. I would like to just add another sheet, but contracts will
not allow that either.