Sumif column name contains "Tax"

Kristina Feocco

Hi All,

I'm using smartsheets to track scores from daily quizzes taken by members over several teams. The end goal is that we want to compare the total scores from each team in a dashboard, so I'm trying to use the sheet summary to calculate the totals.

Basically, each column on the sheet has one employee's name and the dept that they belong in (read "John Smith - Tax" or "Jane Doe - Payroll").

What formula do I need to use to Sumif the column name contains "Tax", "Payroll", etc.?

Mike TV

@Kristina Feocco

Tax Total Score formula:

=SUMIF([Name/Dept]:[Name/Dept], CONTAINS("Tax", @cell), Score:Score)

Payroll Total Score formula:

=SUMIF([Name/Dept]:[Name/Dept], CONTAINS("Payroll", @cell), Score:Score)

Tax Total Score and Payroll Total Score should really be a Sheet Summary etc

Mike TV

@Kristina Feocco

Tax Total Score formula:

=SUMIF([Name/Dept]:[Name/Dept], CONTAINS("Tax", @cell), Score:Score)

Payroll Total Score formula:

=SUMIF([Name/Dept]:[Name/Dept], CONTAINS("Payroll", @cell), Score:Score)

Tax Total Score and Payroll Total Score should really be a Sheet Summary etc