Search code examples
if-statementgoogle-sheetscheckboxsum

only sumif checkbox is checked?


How do I only sum the amounts that are checked on sheet2 for each name?

Sheet1
Column A
Tom
Susan


Sheet2             
Column A    Column B     Column C
 Tom         100         (un-checked)
 Susan       150         (checked)
 Susan       75          (un-checked)
 Tom         25          (checked)
 Susan       50          (checked)

Solved!

   =SUMIFS(Sheet2!B1:B,Sheet2!A1:A,Sheet1!A1:A,Sheet2!C1:C,true)

Output:

Tom   25
Susan 200

Solution

  • =SUMIFS(M2:M,A2:A,"Susan",N2:N,true)