SUMIF statement with two different conditions (Text based and checkbox)
Just to make an official answer:

Use the SUMIFS() function to use 2 or more conditions.

From the documentation:


  The SUMIFS function returns the sum of the cells in a collection where
  the test values meet the given conditions.
  
  SUMIFS(sum-values, test-values, condition, test-values…, condition…)