CODEWITHSUNDEEP
if-statementgoogle-sheetscheckboxsum
user11067130
user11067130

Reputation:

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

Upvotes: 1

Views: 770

Answers (1)

onit
onit

Reputation: 2372

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

Upvotes: 1

Related Questions