help with adding names

C

CHAD

can i add a word before a sum from a different sheet.

ie: i have a total on sheet 1, and on sheet 2 in a cell i place =then i
click on the cell that i want from shhet 1. but what i want to see on sheet 2
is the word TOTAL in front of the number that comes from the sheet 1 cell.

if anyone could help that would be great.

thank you
 
C

CLR

Format the cell on sheet2 as CUSTOM Total 0

or

use this formula on sheet2 instead,

="Total " & Sheet1!A1

Vaya con Dios,
Chuck, CABGx3
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Summing up various Worksheets to one Summary sheet using variables 1
Summary from multiple sheets 1
Lock location of sheet within a spreadsheet 4
adding columns on different worksheets 3
Adding consistant cells. 4
Formula needed for adding every nth column on another sheet 6
adding amounts if criterias are met 1
Excel Is this possible?? 3

Top