Can a cell contain text and perform calculation?

Hello all. In trying to tame a Hydra (mythical monster that regenerates heads when they are cut off...seems the more I work on this, the more things I need to incorporate) of a project. I have posted several questions that many of you Excel Wizards are helping me with...and here is another...

I would like to have a cell in which there is descriptive text and the results of a calculation. For example, in row 2, I want to state the current total number of items in inventory at the top of the sheet in the center of the used cells.

Inventory Total is: SUM(A4:A64,000) as of: Date()

I can't merge cells or manipulate the text in such a way to neatly bring the text and calculation together. And there are actually 2 calculations in the example above. One to SUM the items and one to add the date. Can this be done and can someone help me with the code?

Thanks,
Andrew

you can. try this
="Inventory Total: "&sum(a4:a64)&" as of "&Month(today())&"/"&day(today())&"/"&year(today())

Instead of

Month(today())&"/"&day(today())&"/"&year(today())

I'd recommend just

TEXT(TODAY(),"mm/dd/yyyy")

Thanks barrfly and Paul!! They both work perfectly. Other than smaller code, what is the difference between the 2?
Also, is there a way that I can make the

sum(a4:a64)

RED and BOLD font?

Thanks again!!

The only real difference is the number of calculations each method uses.

Barrfly's method gets the value for the TODAY() function three times, then gets the MONTH, DAY and YEAR values in three more functions, and then concatenates it all resulting in a text string of the current date.

My method gets the value of TODAY() just once, and then uses the TEXT function to present it in the specified format. So two functions instead of seven. In a small set of data you likely wouldn't notice a difference, but if you had 500,000 rows it would likely be noticeable.

As for making parts of a function a different format than the rest, this cannot be done using formulas. Even using VBA you couldn't maintain the formula in the cell and do that, you'd have to convert the formula's result into a static value, and then you could format any or all of it. (Because the VBA would replace the formula with the static value, if you changed the values in A4:A64, the result cell would not get updated - until you ran the macro again, of course.