Looking to filter for unique value and summarize amounts

tlagueux

Hi,

I am not sure this can be done with Smartsheet. In the screenshot, I need to retrieve unique values in the project# column and summarize the values for each project. The bottom part in yellow shows the result I am looking for. 

Any help would be greatly appreciated!

Thierry

J. Craig Williams

This formula in the Car column, where the 196 is

=SUMIFS(Car$3:Car$6, $[Primary Column]$3:$[Primary Column]$6, $[Primary Column]@row)

replace the 3 and 6 with your actual row numbers and the primary column with whatever your ID column name is.

Copy this to the rest of the yellow cells (the 4 columns to the right)

Criag