I have the following formula and would like to add text for eg if the result of the SUMIFS formula is $ 50000, then I want is to state $ 50000 -BR1
It would be appreciated if someone could kindly assist me
Code:
=TEXT(SUM(SUMIFS(B:B,$A:$A,{"40-45","45-50","50-55","*>60*"})),"R #,##0.00")
It would be appreciated if someone could kindly assist me
Last edited: