Sum of one Column based on another

Stephanie Foster

I am trying to calculate the total (sum) of the column "mbrs" based on their affiliation (AFF,DNG,LITE etc). I have tried a =Countif(=Sum(range), criteria) type of formula with no success. Any suggestions on how to calculate without having to filter and count each separately I have over 6k rows.  

L_123

=sumif(affiliation:affiliation,"AFF",mbrs:mbrs)

where affiliation is the column where the AFF DNG LITE are located and mbrs is the column where the values you want to sum are

L_123

=sumif(affiliation:affiliation,"AFF",mbrs:mbrs)

where affiliation is the column where the AFF DNG LITE are located and mbrs is the column where the values you want to sum are