View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
HotRod HotRod is offline
external usenet poster
 
Posts: 147
Default Formula and text in one cell?

I have a formula that SUMS the rows above it but also want to show the
overall percent. Can I do a SUM and text and another SUM in one cell without
additional hidden cells?

Something like this?

=SUM(J5:J20) & "Text here" & SUM((J:20+K:20+L:20)/3)