Monthly Formula Amounts

[crazyforexcel]

Hello,

I could use someone's help for checking formulas in the Actual sheet for monthly amounts. I added up all of the Groceries for the month of January in the Transactions sheet and it totals to:

320.05

The Actual sheet shows 389.93 which is wrong.

Since this is wrong the whole sheet formulas are suspect.

Thank you so much for your help in advance

[Roel Jongman]

When I filter on Groceries in Transactions I also Get 389.93

you seem to want to exclude the amounts row 103 and row 106. why is that?

[crazyforexcel]

Thank you for finding that so soon. I double charged 57.10 accidentally.

I did realize that the Actual sheet isn't accounting for when money goes back for refunds. There is a credit back of 12.78 for groceries but it isn't affecting the Actual sheet.

Can you check this please?

[crazyforexcel]

I guess my question has been solved thank you.