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)
|