Forum Discussion

Stryfe24's avatar
Stryfe24
Copper Contributor
Sep 06, 2023
Solved

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.  ...
  • HansVogelaar's avatar
    Sep 06, 2023

    Stryfe24 

    Let's say the second table (the one on the right) is named Table2. The formula

     

    =SUMIF(Table2[ID], [@ID], Table2[Value])

     

    should work.

     

Resources