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

edwin echeverria
edwin echeverria
2,987 Points

In the Expenses spreadsheet you opened in the first question, the total dollar value of all items in the F&B and Enterta

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

1 Answer

Steven Parker
Steven Parker
231,186 Points

To answer this question, you'll want to use a function for totaling, but also limit that total to just items in the desired categories. The SUMIF function is well suited for this.

I am really struggling with this. I have filtered the spreadsheet to show the F&B and the Entertainment categories and then done a sum on the price column. I have done a sum on the price column when the category is filtered just on F&B then adding that to the sum of the price column when the category is filtered on just Entertainment. Both give me different answers even though I would expect them to be the same. Can anyone help where I am going wrong?

Steven Parker
Steven Parker
231,186 Points

Filtering to limit what is shown won't automatically limit what gets summed. Be sure to use SUMIF with appropriate arguments to get the correct sum.

Also, to reach the most students, always start a fresh question instead of asking one as an answer or comment to an old question.