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 trialDavid Griffith
8,311 PointsFor this question in the test "In the Expenses spreadsheet you opened in the first question, the total dollar value of a
For this question on the test: "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:" I get the answer $9431. I genuinely am not sure why this is not the correct answer.
6 Answers
Steven Parker
231,198 PointsI got a significantly smaller value. What formula did you use?
David Griffith
8,311 PointsI did: =SUM(B5:B176), was it looking for the sum of F&B and Entertainment?
Steven Parker
231,198 PointsSo "SUM" isn't going to do the filtering you need. You'll probably need "SUMIF".
Kortney Field
14,091 PointsThese references helped me get the answers.
- http://www.microknowledge.com/subtotal-func-to-sum-filtered-data-excel/
- https://support.microsoft.com/en-us/office/subtotal-function-7b027003-f060-4ade-9040-e478765b9939
=SUBTOTAL(9, B5:B176)
David Griffith
8,311 Pointsi just got the right answer, strangely I don't think I did anything else. Thanks for looking at this for me
Steven Parker
231,198 PointsWithout "SUMIF"? What was the formula that gave you the correct value?
Candace Steinebach
4,726 PointsYou will want to use the sumif formula along with the absolute value concept you learned. =sumif(range,criterion,sumrange)
Remember that absolute value uses the $ symbol.
I hope this help.
Henry Spock
20,615 PointsThe video didn't cover "Sumif." /manshrugging Money spent.
The problem is when you sort, the expenses aren't visually on the page, but when you input a formula, it's still adding every value between the listed ranges.
Two ways around this: Sort instead of filter, then apply the formula.
Filter, then copy the values down below to where there are no filtered rows and apply the formula to the copied values.
Sumif very probably works, but as I haven't learned that yet since the course didn't teach it, I can't say.