View Single Post
 
Old 07-19-2022, 08:40 PM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 770
ArviLaanemets is a splendid one to beholdArviLaanemets is a splendid one to beholdArviLaanemets is a splendid one to beholdArviLaanemets is a splendid one to beholdArviLaanemets is a splendid one to beholdArviLaanemets is a splendid one to beholdArviLaanemets is a splendid one to behold
Default

On fly!

Leave the column with sum as it is. Add an empty column next to it, with formula like
Code:
= "" & Q6 & "+" & R6 & "+" & S6 & "+" & T6 & "+" & U6
NB! The added column displays all components of sum as string! You can take it as comment of formula.

And in case the components of original sum are formulas instead cell references, like:
Code:
= SUM(Formula1,Formula2,Formula3,Formula4)
in added column you use formula:
Code:
= "" & Formula1 & "+" & Formula2 & "+" & Formula3 & "+" & Formula3 & "+" & Formula4
Reply With Quote