Is there a way to show my Concatenate(SumIf formula resulting into a text cell that shows the formula of two cells. So for example, I have:

Row 1: List of Dates.

Column A: I have the dates of clients months.

Column B: I have names

Column C: I have the totals

What I'm trying to do is showing what adding what, so in April it shows Willy twice, and so I want it to show: =C3(5751) C9(8852)

What I have:

CodePudding user response：

This one should work if I understood your question correctly:

="="&TEXTJOIN(" ",TRUE,IF(A3&B3=A3:A25&B3:B25,"C"&ROW(C3:C25)&"("&C3:C25&")",""))

There's no reason to use sumif; as the result you want doesn't have the actual sum there.