Forum Discussion
Stryfe24
Sep 06, 2023Copper Contributor
SUMIF with unique indexing
Hi all, I am trying to generate a calculation which shows where a unique ID has separate rows and totals the value for all cells in a column where that unique identifier is present in the row. ...
- Sep 06, 2023
Let's say the second table (the one on the right) is named Table2. The formula
=SUMIF(Table2[ID], [@ID], Table2[Value])
should work.
HansVogelaar
Sep 06, 2023MVP
Let's say the second table (the one on the right) is named Table2. The formula
=SUMIF(Table2[ID], [@ID], Table2[Value])
should work.
- Stryfe24Sep 06, 2023Copper ContributorPerfect, thank you!