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!

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

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

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.