Nesting a SUMIF function

Hi community!

I have several columns of numbers that I want to add up in different ways.  Next to these are two checkbox columns.  I want to add up each column individually if both checkboxes are checked.


So in the example I have a series of data columns Q1 to Q4, each with a row label and next to each row label are 3 checkboxes that help me further define the data.  At the bottom I total each column, then use a formula such as =SUMIF(CatA1:CatA13, 1, [Q1]1:[Q1]13) to total up the column by category. 

What I need to do is get a total that match two criteria, a tick in CatB and if the corresponding data column contains the word "blue".

Any ideas? 




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!