Since you can use & for concatenate, how about something like this:

=TEXT(SUM(F7:F26), "#,###") & " Brick"

--
Kevin Vaughn


"ChasDavisIII" wrote:

How do I use the folowing formula and show the number with a unit seperating
comma like 12,469?

=CONCATENATE(SUM(F7:F26)," Brick")