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

David Griffith
David Griffith
8,311 Points
Posted by David Griffith
David Griffith
8,311 Points

For 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
Steven Parker
231,248 Points
Steven Parker
Steven Parker
231,248 Points

I got a significantly smaller value. What formula did you use?

David Griffith
David Griffith
8,311 Points
David Griffith
David Griffith
8,311 Points

I did: =SUM(B5:B176), was it looking for the sum of F&B and Entertainment?

Steven Parker
Steven Parker
231,248 Points
Steven Parker
Steven Parker
231,248 Points

So "SUM" isn't going to do the filtering you need. You'll probably need "SUMIF".

Kortney Field
Kortney Field
14,091 Points
Kortney Field
Kortney Field
14,091 Points

These references helped me get the answers.

=SUBTOTAL(9, B5:B176)

David Griffith
David Griffith
8,311 Points
David Griffith
David Griffith
8,311 Points

i just got the right answer, strangely I don't think I did anything else. Thanks for looking at this for me

Steven Parker
Steven Parker
231,248 Points
Steven Parker
Steven Parker
231,248 Points

Without "SUMIF"? What was the formula that gave you the correct value?

Candace Steinebach
Candace Steinebach
4,726 Points
Candace Steinebach
Candace Steinebach
4,726 Points

You 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
Henry Spock
20,615 Points
Henry Spock
Henry Spock
20,615 Points

The 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.