Welcome to the Treehouse Community
Looking to learn something new?
Quiz question, Formula keeps disappearing from Spreadsheet
I'm trying to do the quiz question:
Click this link to open a copy of a spreadsheet: Expenses spreadsheet.
Use the SUMIF function to calculate the total value of all F&B expenses. The total value is $
I'm entering the following as my formula: =SUMIF(A3:A176,"F&B",C3:C176)
When I compare this to the formula in the SumIf video, I don't see any difference in syntax, yet when I hit enter, the formula I typed disappears and is just replaced with a zero. I've been trying to figure this out for a week now. I've looked at Google's documentation and haven't found anything helpful. What Am I missing??
Paul Bentham24,090 Points
You have the wrong Range.
You need to look in the range in Column C for "F&B" and sum up the relevant cells in Column B
So it should be: =SUMIF(C3:C176,"F&B",B3:B176)
Thanks, I thoughtI already tried that but I guess not.