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

atomictds
atomictds
333 Points
Posted by atomictds
atomictds
333 Points

First question on Finding # of employees for guests

Not sure what this question is asking for without a spreadsheet giving me to cell #s. I found a SUMIF function that works on a test case, but it would be too specific to be an answer. I used =ROUNDUP(SUMIF(A2:A3031,A3031/5)) because I created a spreadsheet. I can't figure out how to answer the question without a spreadsheet to refer to.

1 Answer

Travis Alstrand
seal-mask
.a{fill-rule:evenodd;}techdegree seal-36
Travis Alstrand
Treehouse Project Reviewer
Travis Alstrand
.a{fill-rule:evenodd;}techdegree seal-36
Travis Alstrand
Treehouse Project Reviewer

This one is just asking for the function you would provide to solve this problem, you don't need to see any cells or data besides what's provided. You're correct in using ROUNDUP(), but you don't need to provide this with cell names and we don't need to use SUMIF either.

You just want to divide the expected total of guests by 15, then provide how many decimal places to round to, which in this case, would be 0 to get it to the nearest integer.