Sum of one Column based on another


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.  

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!