If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Adding Multi-part Formula
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? |
#2
|
|||
|
|||
Adding Multi-part Formula
=SUM(H61:H961,J61:J961)
=2*SUM(A60:A960) Adjust the ranges as appropriate. -- David Biddulph "PhilosophersSage" wrote in message ... 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? |
#3
|
|||
|
|||
Adding Multi-part Formula
Can you use the SUM formula? Or how about naming the range, then just
write =Sum(RangeName) to get the total? --JP On Oct 6, 10:41*am, PhilosophersSage wrote: 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? |
#4
|
|||
|
|||
Adding Multi-part Formula
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. "David Biddulph" wrote: =SUM(H61:H961,J61:J961) =2*SUM(A60:A960) Adjust the ranges as appropriate. -- David Biddulph "PhilosophersSage" wrote in message ... 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? |
Thread Tools | |
Display Modes | |
|
|