How do I display results of a summation in the following format?

[Nh2]

Formula: ="Total = "&round(sum(a1:a12),2)"
Assuming the result is 123456.78.

Can the final results be displayed in the cell with number format
(accounting) as...
Total = 123,456.78 ?

 

[Jacob Skaria]

Try the below.

="Total = "& TEXT(SUM(A1:A12),"#,##.00")

If this post helps click Yes

 

[Jacob Skaria]

To handle just decimals ie; to display .563 as 0.56 and not as .56 try the
below

="Total = "& TEXT(SUM(A1:A12),"#,##0.00")

If this post helps click Yes