Welcome to the Treehouse Community

The Treehouse Community is a meeting place for developers, designers, and programmers of all backgrounds and skill levels to get support. Collaborate here on code errors or bugs that you need feedback on, or asking for an extra set of eyes on your latest project. Join thousands of Treehouse students and alumni in the community today. (Note: Only Treehouse students can comment or ask questions, but non-students are welcome to browse our conversations.)

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and a supportive community. Start your free trial today.

Data Analysis Spreadsheet Basics Getting Started With Spreadsheets Getting Started With Spreadsheets Review

I am stuck on this Spreadsheet Basics Quiz

The Question is... In the Expenses spreadsheet you opened in the first question, the total dollar value of all items in the F&B and Entertainment categories is: $

When I use a filter in Sheets and unselect every category besides F&B and Entertainment and use the SUM function to calculate the total value I get $9,431.00. This however seems to be incorrect. Any help would be much appreciated.

1 Answer

Brandon White
seal-mask
MOD
.a{fill-rule:evenodd;}techdegree seal-36
Brandon White
Treehouse Moderator

Hi Louis,

I’m pretty sure filter only hides certain rows from the sheet from your view, it doesn’t make it as so they (or their values) temporarily don’t exist. And so if you’re using the SUM function and you’re dragging across the entire column, you’ll still be including every value in the column (even the ones that you can’t see).

I’m pretty sure when I did this quiz I went through and clicked every value I wanted to include individually, but it would probably be cleaner to use a SUMIF function, then you can use the logic that sums the value if the category column for that row is equal to F&B and Entertainment.

I’m sure there are many other ways to solve this as well.