Is there a formula in Excel that puts some text in a specific cell?

For example I want F16 cell to have text "Sum total is:"

Before you answer "click on F16 and enter the desired text" the point of the question is that I do not know in advance that it is going to be F16. Whether it is F12 or F24 is dependent upon FILTER function that produces a variable number of rows above "Total row"

CodePudding user response：

Try VSTACK():

Formula in D1:

=LET(x,FILTER(B1:B5,A1:A5="a"),VSTACK(x,"Sum total is:  "&SUM(x)))