Combining Text and Formula in Same Cell

[TQO23]

Hi All.

Is it possible to combine a small amount of text followed by a formula in the same cell.

Each month I summarise a number of lines into one line so that my spreadsheet doesn't get too large. What I'd like to do is have the summary as a running total throughout the month BUT I don't want to increase the number of columns. Combining text and a formula would be perfect but I've no idea where to start.

I have 3 running calculations throughout the month: Wins, Losses and %Age Wins

An example cell content would be: Total Wins: followed by the formula =Count($J$6:$J16)

Is this at all possible and if so what would be the format please?

Thanks in advance.

Nigel
TQO23

 

[R Pelle]

E.g. J17 ="Total Wins: " & COUNT(J1:J16)

Rob

 

[TQO23]

E.g. J17 ="Total Wins: " & COUNT(J1:J16)

Rob

That easy Rob!! Tested and perfect.

Thanks so much for a prompt response.

Regards

Nigel

 

[R Pelle]

Thanks for the feedback!

Rob