Excel formula not returning expected results

Copper Contributor

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 you see in the last screenshot below. A $500 difference. 


Can anyone explain what's going on? I'd appreciate any insight!


Screenshot 2024-06-29 at 5.45.24 PM.png

To check the formula, I went to the List of Transactions tab and did the following:

  • Column G: Set the filter to ≥ 0 (per screenshot below) 
  • Screenshot 2024-06-29 at 5.48.53 PM.png
  • Column J: Set the filter to show only "R" (screenshot below)
  • Screenshot 2024-06-29 at 5.51.14 PM.png
  • Column G: Noted the total (screenshot below)


  • Screenshot 2024-06-29 at 5.54.41 PM.png
  • Checked the line numbers to ensure that all of them are ≥3 and ≤ 316, which they are


4 Replies


Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?

Hans, I appreciate you asking! I've attached a scrubbed workbook (240630 Calculation Error), having removed sensitive info and retained rows that calculate into column G.

Thanks in advance for taking a look!


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!!