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 Spreadsheet Functions & Shortcuts Review More Spreadsheet Functions

Sunitha Chilukuri
Sunitha Chilukuri
137 Points

USE 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
Steven Parker
229,644 Points

The 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
STAFF
Michael Watson
Treehouse Teacher

Hi Sunitha, what is the question you are asking?