Forum Discussion
Excel formula not returning expected results
Out of curiosity, I manually checked the formula in the first screenshot below and got a different result. (As you see, the formula returned $49,515.63, while my manual check returned $49,015.63, as ...
Thanks. Row 4 in your data sheet is hidden:
If you unhide row 4 by increasing its row height, you'll see that G4 contains $500. Since J4 is "R", G4 is included in the SUMIFS result.
Beautiful. Thanks so much, Hans!!