Count IF Range Match to Column Header

nlewis ✭✭
edited 05/09/24 in Formulas and Functions


I have a master sheet with 150 columns with unique names. In these columns are check boxes. Depending on the row this box can be checked or empty. I'd like to write a CountIFS function that allows the range to be selected that matches the specified column name. I don't want to manually select that column for the formula. I have over 150 columns and this could get tedious. I know how to write the majority of the Count IF, but how do I get the "range" portion to select based on the column header name match?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!