Forum Discussion
Macro for adding win / loss records
Hi there. I'm looking for a way to add home won/loss records to away won/loss records to get a total won/loss record. For instance, if cell C2 is home won/loss record and that equals 58-37 and cell D2 is away won/loss record and that equals 34-49, I would like those two cells to be summed into a total won/loss record of 92-86 in cell A2. All of the cells are formatted as text. Thanks in advance for your help!
=LET(wlh, TEXTSPLIT(C2, "-"), wla, TEXTSPLIT(D2, "-"), INDEX(wlh, 1)+INDEX(wla, 1)&"-"&INDEX(wlh, 2)+INDEX(wla, 2))
HansVogelaar Thanks so much for the quick response!
