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 Build a Spreadsheet Review Spreadsheet Basics

John Grillo
John Grillo
30,241 Points

The total number of fish which passed through the dam in 2001 was

I'm going through the spreadsheet and the videos, but can't quite seem to figure out what I'm getting wrong. I tried using filters to get the answer, but it keeps saying it's wrong. Will someone who has gotten the right answer walk me through the process?

...yes, you could use a filter on the year column, then deselect all the years except for 2001, then sum from c65:m65 and you have your answer.

John Grillo
John Grillo
30,241 Points

Yeah, i figured it out literally just after I posted the comment. Don't you hate it when that happens? Chad, i'd give you best answer but you made a comment instead.

1 Answer

Michael Watson
STAFF
Michael Watson
Treehouse Teacher

Echoing Chad's comment above. I think his second proposed method is the quickest way, a la to sum the row.