Welcome to the Treehouse Community
Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.
Looking to learn something new?
Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.
Start your free trial
Joshua Richardson
2,417 PointsI'm unclear how I'm getting this wrong (I get 9431.00). I don't know what to say, I'm an experienced spreadsheet user.
I filtered on the categories and summed up the amounts. It's a simple task and after multiple tries I'm not getting it. I kinda do this for work so, all this is a bit embarrassing. 😊 Is the answer formatting I'm using somehow incorrect?
2 Answers
Steven Parker
241,970 PointsYou forgot to show your actual formula or identify which quiz question you are working on, but remember that filtering only affects which rows are displayed. It does not not restrict which rows will be included in a SUM().
Hint: the SUMIF() function might be a better fit for what you need.
Joshua Richardson
2,417 PointsHI Steven, Apologies, I thought the quiz question would accompany my question. I appreciate your helpful clarification, and the SUMIF() worked for me. Many thanks! Josh
Steven Parker
241,970 PointsSteven Parker
241,970 PointsJoshua Richardson — Glad to help. You can mark a question solved by choosing a "best answer".
And happy coding!