How to count the total value of unique items

Please try this:

1. Use a Helper Column to Identify Unique Projects:
   • Add a new column to your data to create a unique identifier for each project at each stage. For example, concatenate the project name and stage.
   • Formula: =A2 & "-" & D2 (assuming A2 is the project name and D2 is the stage).
2. Remove Duplicates:
   • Use Excel's Remove Duplicates feature on the helper column to filter out duplicate entries.
   • Select the helper column, go to the Data tab, and click Remove Duplicates.
3. Filter Approved Projects:
   • Use the Filter feature to display only the approved projects.
   • Select your data range, go to the Data tab, and click Filter. Then, filter the column that indicates approval status.
4. Sum the Values:
   • Use the SUMIFS function to calculate the total value of unique approved projects at each stage.
   • Formula: =SUMIFS(C:C, B:B, "Approved", D:D, "L1") (assuming C is the value column, B is the approval status column, and D is the stage column).