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
Lee Ravenberg
10,018 PointsI can't figure out how to reference a how to reference all cells in column C that yields the value of 'other'.
I am trying to use the function MAX on all cells in column b (dollar values) that are in the same row where column C yields the value of 'other'. How do I write a formula for this?
1 Answer
Balazs Peak
46,160 PointsI checked this out for you, and I succeeded using the MAXIFS function. I won't flat out tell you the solution since here in the Treehouse Community, we try to help a little and let people figure it out themselves. Investigate the MAXIFS function with Google a little bit, and let me know how it goes ;) Much love
Lee Ravenberg
10,018 PointsLee Ravenberg
10,018 PointsThank you Balazs for your reply. I haven't had the chance to try that function out, but I will let you know as soon as I do! :)
Balazs Peak
46,160 PointsBalazs Peak
46,160 Pointsall right ;)
Michael Watson
Treehouse TeacherMichael Watson
Treehouse TeacherLove it Balazs Pukli! Your response is what I really like to see our students give to eachother. It was a fast response time, helpful, but you didn't just give it away. You nudged Lee in the right direction. That helps so much with the learning process.
Lee Ravenberg, hopefully you're well on your way at this point, but just in case, here's some (documentation on the MAX function in Sheets.)[https://support.google.com/docs/answer/3094013?hl=en]