I have been trying to make this work for the past hour and seems right but is not working.
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))
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))