ADDRESS formula INDIRECT(ADDRESS(ROW()-2 COLUMN()+2))})) add Text

Question

Hi There is any way to add text this formula

=IFERROR(DGET(Data,"Qty",{"Name";"=" & INDIRECT(ADDRESS(ROW()-24, COLUMN()+2))}))

Results will be "117"

I Want add Text "Total " So Results will be "Total 117"

Thank you

Answer 1

Try adding "Total " & to your formula. Example:

=IFERROR("Total " & DGET(Data,"Qty",{"Name";"=" & INDIRECT(ADDRESS(ROW()-24, COLUMN()+2))}))

Alternatively, if you wish for the numbers to retain their value you can go to Custom Number Format and change the format there.

Type Total in the form field and the cell values will be retained.

Let me know if this works for you.