Welcome to the Treehouse Community
Looking to learn something new?
The total dollar value of the Entertainment and F&B Category 9431.00 is incorrect. How is this?
I did =SUM(B5:B176) which equalled 9431.00 dollars while displaying the F&D and Entertainment category. I inputted this into the space provided and it came up as incorrect
Try copying and pasting your filtered list to a new sheet and then sum. Hidden values are included otherwise. For this example however you can also sort by category first, then filter, then sum.