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

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

I arrived at a different answer

I filtered F&B and Entertainment category and did a =SUM(B5:B176) on the price column but arrived at the result $9341 which the quiz says it is incorrect.

What did i do wrong?

1 Answer

Steven Parker
Steven Parker
231,198 Points

The range B5:B176 would cover every item of all categories except for the first two.

Please explain the process you used when you "filtered F&B and Entertainment category".

Perhaps you applied a view filter instead of a data filter. That would only affect the rows that are shown, not the ones the formula acts on, and could explain the issue.

You might want to try using the SUMIF function, it has data filtering capability built-in.

How should i use the SUMIF function?

is the command =SUMIF(B2:B176, "F&B"&"Entertainment") ?

Or how should i key in the function?

Steven Parker
Steven Parker
231,198 Points

You'll need to move the value column range to the the third argument of SUMIF. The first argument will be for the column where the categories are.

And I don't think you can combine the filter criteria like that. But you could have two SUMIF functions, one for each category, and then add them together.