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?
Comments

=SUMIFS([Q1]1:[Q1]13, CatA1:CatA13, 1, Data1:Data13, FIND("Blue", @cell) > 0)

This is perfect! Thank you.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.1K Get Help
 380 Global Discussions
 212 Industry Talk
 442 Announcements
 4.6K Ideas & Feature Requests
 140 Brandfolder
 129 Just for fun
 130 Community Job Board
 450 Show & Tell
 30 Member Spotlight
 1 SmartStories
 289 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!