Today I have come across a situation where i want to have the cell to descriptive and to have summation of some cells. I have got information on how to do it. Please find below
I want a cell to be on top those with description and summation value
Expected output data:
|Sum = 9|
To get the output, I have written the following function
="Sum = "& SUM(A2:A4)
We can append and prepend the text to excel function to combine text and numbers as well.
Please send your comments and feedback to email@example.com