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 trialGilbert Rifkin
3,116 PointsExpenses
I thought I was putting in the right information to the SUMIF function but no matter how many variations I try I keep receiving the answer "0"
Zimri Leijen
11,835 PointsIf you want people to help, it would be helpful to show some example code of what you have tried.
Gilbert Rifkin
3,116 PointsI wrote =SUMIF(A3:A176,"F&B",B3:B176) is the code I figured is correct. I also tried multiple variations e.g.: =SUMIF(B3:B176,"F&B",A3:A176)
1 Answer
Steven Parker
231,198 PointsThe range is testing the wrong column.
Column A contains the item descriptions ā but you want to test the Category which is column Ā CĀ .
Steven Parker
231,198 PointsSteven Parker
231,198 PointsWhat's the complete formula you enter?