I am attempting to write a SUMIFS formula but it wasn't working. So, I thought I'd take each argument at a time so I wrote a simple SUMIF formula. (see attached file). The result is not the SUM of the cells but only the amount in the first cell of the range. I copied and pasted the dates so both date cells are formatted the same. I then hard entered the numbers that I need the formula to sum to ensure a formula in those cells wasn't causing the problem. I still can't get this basic SUMIF formula to work so I can move on and created my formula based on multiple criteria. Any assistance would be greatly appreciated to explain what is wrong.
help.xlsx