Sum of one Column based on another
Options
Best Answer

=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
Answers

=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
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!