Share via

precede function with text

Anonymous
2011-10-11T09:03:25+00:00

Is it possible to get a cell to display both a piece of text and the result of a function?

I want a cell to show something like "Total number of Items: 1234"

1234 is the result of a fuction [ probably countifs ]

Thanks

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2011-10-11T11:19:55+00:00

Hi,

You can also use concatenate function.

for example

=CONCATENATE("Total number of Items: ", COUNTIFS(A1:A10,">5"))

Was this answer helpful?

0 comments

Answer accepted by question author

Anonymous
2011-10-11T09:13:57+00:00

Hi,

Concatenate the string and the formula like this

="Total number of items "&COUNTIF(A1:A20,B1)

if you need help with the COUNTIF(S) then post back with details.

Was this answer helpful?

0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest