Suppose you have enteries in Rows or Columns then you can put this formula in
a cell, where you would like to show sum:

Syntax: ="Whatever text you want : " & SUM(Range)

Example:
="Total : " & SUM(A4:D4)
--
Malik


" wrote:

Please help on

How can I put text and formula in a same cell i.e. This is total: ####
(sum of different cell)

Thanks