Difficult to create formula for this situation

Question

My Conditions are:

if h7:h15=="IN" AND k7:k15="YES" then Sum(m7:m5)

My Try:

=ARRAYFORMULA(if(and(H7:H15="IN",M7:M15="YES"),sum(K7:K15)) // ==> always returns false

=if(And(H7="IN",M7="YES"),sum(K7:K15),"FALSE") // same always false

Am very beginner in spreadsheet!!!

Answer 1

As per my comment above, you should be able to utilise sumifs. See attached example.