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 trialedwin echeverria
2,987 PointsIn 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
231,186 PointsTo 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.
Ruth Browning
86 PointsRuth Browning
86 PointsI 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
231,186 PointsSteven Parker
231,186 PointsFiltering 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.