Aggregate all the amounts tied to the Client Id's in another column

System

This discussion was created from comments split from: Use Sumifs and Index Match to add values in a multiselect lookup table.

christianmorey

I am trying to do something similar. Sheet 1 has a Client ID & and amounts associated with those Client ID's. I also have those Client ID's on sheet 2 and would like to aggregate all the amounts tied to the Client Id's in another column. So for instance:

Sheet 1

Client ID Amount

101.1 500

101.1 200

102.1 100

102.1 530

Sheet 2 outputs

Client ID (already entered) Aggregate Amount(Needed)

101.1 700

102.1 630

What formula would I need to get the Aggregate Amounts using the data from sheet 1?

Paul Newcome

@christianmorey It sounds like you need a standard SUMIFS.

https://help.smartsheet.com/function/sumifs