Hello, I am looking for sum help with a nested 'And' formula inside a Sumif. Here is simplified example of what I am trying to acheive.
Interest Rate Principle $ Amount
1.0% 1
1.1% 2
1.2% 3
1.3% 4
1.4% 5
1.5% 6
I am trying to sum certain principle amounts that are within a range of interest rates. For example:, When I try to sum all principle amounts that are within the range of greater than 1% interest and less than 1.3% , I will type this formula =SUMIF($H$9:$H$14,AND(">1%","<1.3%"),$I$9:$I$14) Assume that the '$' cells in the formula are where the 2 columns are located in the excel worksheet.
My problem is I am receiving a '0' when I enter this formula when I should be receiving a '5'. I assume that since I am receiving a 0 and not an error that it is something wrong with my And formula??
Can anyone help?
Thank you!
Bookmarks