View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
PhilosophersSage PhilosophersSage is offline
external usenet poster
 
Posts: 55
Default 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?