Forum Discussion
need a suggestion please
I am trying to add up the numbers in the cells of column j, based on the year designated in column k. I'm not sure what formula will do that. I've looked at IF statements, VLOOKUP and XLOOKUP. They r...
If you have Excel 365
= LET(
distinctYears, UNIQUE(year),
annualTotals, SUMIFS(amount, year, distinctYears),
HSTACK(distinctYears, annualTotals)
)would return the result you specify.
thank you!
