Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding only part of a column | Excel Worksheet Functions | |||
Multi Part Lookup | Excel Discussion (Misc queries) | |||
Find last name in multi-part name? | Excel Worksheet Functions | |||
Adding workdays as part of the equation | Excel Worksheet Functions | |||
adding part of a function on condition. | Excel Worksheet Functions |