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 trialSunitha Chilukuri
137 PointsUSE THE SUMIF FUNCTION TO CALCULATE THE TOTAL EXPENSES OF F&B
Item Price Category Bus pass $130.00 Transport Rent $1,500.00 Lodging Groceries $300.00 F&B Lunch $8.00 F&B Coffee $5.00 F&B Book $25.00 Education Smoothie $9.00 F&B Shoes $99.00 Clothing Lunch $10.00 F&B Dinner $45.00 F&B Movie $20.00 Entertainment Book $15.00 Education Coffee $5.00 F&B Lunch $9.00 F&B Dinner $33.00 F&B Groceries $200.00 F&B Hair Salon $100.00 Other Glasses $95.00 Other T-shirt $20.00 Clothing Internet $99.00 Other Lunch $10.00 F&B Coffee $5.00 F&B Printer cartridge $50.00 Other Book $30.00 Entertainment Movie $20.00 Entertainment Lunch $15.00 F&B Coffee $5.00 F&B Phone bill $50.00 Other Flight $540.00 Transport Taxi $60.00 Transport Hotel $1,200.00 Lodging Lunch $8.00 F&B Coffee $5.00 F&B Doctor Office $60.00 Other Surfboard $318.00 Other Lunch $5.00 F&B Gift $20.00 Other Lunch $13.00 F&B Coffee $5.00 F&B Groceries $300.00 F&B Lunch $8.00 F&B Coffee $5.00 F&B Book $25.00 Education Smoothie $9.00 F&B Shoes $99.00 Clothing Lunch $10.00 F&B Dinner $45.00 F&B Movie $20.00 Entertainment Book $15.00 Education Coffee $5.00 F&B Lunch $9.00 F&B Dinner $33.00 F&B Groceries $200.00 F&B Glasses $95.00 Other T-shirt $20.00 Clothing Internet $99.00 Other Lunch $10.00 F&B Coffee $5.00 F&B Book $30.00 Entertainment Movie $20.00 Entertainment Lunch $15.00 F&B Coffee $5.00 F&B Phone bill $50.00 Other Lunch $8.00 F&B Coffee $5.00 F&B Book $10.00 Education Cooking Class $200.00 Education Lunch $5.00 F&B Gift $20.00 Other Lunch $13.00 F&B Coffee $5.00 F&B Bus pass $130.00 Transport Groceries $300.00 F&B Lunch $8.00 F&B Coffee $5.00 F&B Book $25.00 Education Smoothie $9.00 F&B Shoes $99.00 Clothing Lunch $10.00 F&B Dinner $45.00 F&B Movie $20.00 Entertainment Book $15.00 Education Coffee $5.00 F&B Lunch $9.00 F&B Dinner $33.00 F&B Groceries $200.00 F&B Glasses $95.00 Other T-shirt $20.00 Clothing Internet $99.00 Other Lunch $10.00 F&B Coffee $5.00 F&B Hat $25.00 Clothing Book $30.00 Entertainment Movie $20.00 Entertainment Basketball game $47.00 Entertainment Lunch $15.00 F&B Coffee $5.00 F&B Lunch $8.00 F&B Coffee $5.00 F&B Shoes $500.00 Clothing Lunch $5.00 F&B Gift $20.00 Other Lunch $13.00 F&B Coffee $5.00 F&B Belt $65.00 Clothing Lunch $8.00 F&B Coffee $5.00 F&B Book $25.00 Education Smoothie $9.00 F&B Shoes $99.00 Clothing Lunch $10.00 F&B Dinner $45.00 F&B Movie $20.00 Entertainment Book $15.00 Education Coffee $5.00 F&B Lunch $9.00 F&B Dinner $33.00 F&B Groceries $200.00 F&B Glasses $95.00 Other Sweatshirt $40.00 Clothing Internet $99.00 Other Lunch $10.00 F&B Milk $2.00 F&B Coffee $5.00 F&B Printer cartridge $50.00 Other Book $30.00 Entertainment Movie $20.00 Entertainment Lunch $15.00 F&B Coffee $5.00 F&B Phone bill $50.00 Other Bus pass $130.00 Transport Lunch $8.00 F&B Coffee $5.00 F&B Doctor Office $60.00 Other Flowers $30.00 Other Lunch $5.00 F&B Gift $20.00 Other Lunch $13.00 F&B Coffee $5.00 F&B Bus pass $130.00 Transport Groceries $300.00 F&B Lunch $8.00 F&B Lunch $4.00 F&B Coffee $5.00 F&B Book $25.00 Education Smoothie $9.00 F&B Shoes $99.00 Clothing Lunch $10.00 F&B Pac Man $10.00 Other Dinner $45.00 F&B Movie $20.00 Entertainment Book $15.00 Education Coffee $5.00 F&B Lunch $9.00 F&B Dinner $33.00 F&B Groceries $200.00 F&B Glasses $95.00 Other T-shirt $20.00 Clothing Internet $99.00 Other Lunch $10.00 F&B Coffee $5.00 F&B Book $30.00 Entertainment Movie $20.00 Entertainment Lunch $15.00 F&B Coffee $5.00 F&B Bus pass $130.00 Transport Lunch $8.00 F&B Coffee $5.00 F&B Museum $15.00 Other Coffee $5.00 F&B Lunch $5.00 F&B Gift $20.00 Other Lunch $13.00 F&B Coffee $5.00 F&B
2 Answers
Steven Parker
231,268 PointsThe answer to the question is a number, but to get that number you need to use the SUMIF
function on the live spreadsheet. A text copy of the spreadsheet won't be very useful.
If you need a reminder about how to use the function, review The SUMIF Function video.
Michael Watson
Treehouse TeacherHi Sunitha, what is the question you are asking?