I have 2 tables one contains account numbers and the other has balances. I need to write a statement to find the sum of the balance column when account no is > 110101016 and <110101029.

This is what i was using but it returns a zero while there are actual values:

=SUM((A2:A20="110101016")*(A2:A20="110101029")*(B2:B20))