Treehouse | Community

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

Ozaveshe Balogun
11,766 Points
Hi. Please why is this equation wrong ? ROUNDDOWN(15*3030, 0).

Posted December 13, 2021 11:02am by Ozaveshe Balogun

Ozaveshe Balogun
11,766 Points
1 Answer
nicolaspeterson
8,569 Points
I really enjoyed this course. Thanks Michael!

Posted October 20, 2021 10:07am by nicolaspeterson

nicolaspeterson
8,569 Points
1 Answer
nicolaspeterson
8,569 Points
How do you copy the formulas?

Posted October 20, 2021 9:49am by nicolaspeterson

nicolaspeterson
8,569 Points
1 Answer
nicolaspeterson
8,569 Points
After transposing, the datasheet copied itself a dozen times.

Posted October 20, 2021 9:36am by nicolaspeterson

nicolaspeterson
8,569 Points
1 Answer
nicolaspeterson
8,569 Points
I watched this video twice and I still don't get what the usefulness of CHOOSE is...

Posted October 20, 2021 7:48am by nicolaspeterson

nicolaspeterson
8,569 Points
1 Answer
nicolaspeterson
8,569 Points
Can you select multiple criteria for a SUMIF?

Posted October 20, 2021 7:44am by nicolaspeterson

nicolaspeterson
8,569 Points
1 Answer
nicolaspeterson
8,569 Points
Functions are not case-sensitive.

Posted October 20, 2021 7:24am by nicolaspeterson

nicolaspeterson
8,569 Points
1 Answer
nicolaspeterson
8,569 Points
I didn't quite get the mixed reference part...

Posted October 20, 2021 7:08am by nicolaspeterson

nicolaspeterson
8,569 Points
1 Answer
nicolaspeterson
8,569 Points
In my spreadsheet copy, the sum function auto-filled.

Posted October 20, 2021 6:26am by nicolaspeterson

nicolaspeterson
8,569 Points
1 Answer
Veronica L
1,623 Points
Hello. I am having a hard time averaging after filtering. I keep getting the total for all of the cells ($11,061)

Posted July 7, 2021 2:46am by Veronica L

Veronica L
1,623 Points
0 Answers
Maurice Moore
12,487 Points
Tried multiple test and the total I get is 13...

Posted June 3, 2021 3:11pm by Maurice Moore

Maurice Moore
12,487 Points
0 Answers
Shakran Mushtaq
81 Points
Difference between formula and function?

Posted May 16, 2021 7:44pm by Shakran Mushtaq

Shakran Mushtaq
81 Points
1 Answer
Kim B
3,944 Points
Count Function - Google Sheet's... Help?

Posted April 30, 2021 10:12am by Kim B

Kim B
3,944 Points
1 Answer
teodoro gonzalez
195 Points
The video does not run

Posted April 12, 2021 10:15pm by teodoro gonzalez

teodoro gonzalez
195 Points
1 Answer
angiem
1,489 Points
Links to US BEA and United Nations Statiscs are broken.

Posted April 2, 2021 8:07pm by angiem

angiem
1,489 Points
1 Answer
angiem
1,489 Points
Keyboard shortcut documentation is not in the teacher's notes as mentioned at the end of the video.

Posted April 2, 2021 7:20pm by angiem

angiem
1,489 Points
1 Answer
Amber Prince
Front End Web Development Techdegree Graduate 16,139 Points
Not sure what I'm doing wrong. The question is asking to give the year of the most steelhead. I put 2009.

Posted April 2, 2021 2:20am by Amber Prince

Amber Prince
Front End Web Development Techdegree Graduate 16,139 Points
1 Answer
Louis Espinoza
217 Points
I am stuck on this Spreadsheet Basics Quiz

Posted March 12, 2021 7:17am by Louis Espinoza

Louis Espinoza
217 Points
1 Answer
Brittany Daniels
512 Points
Is the "total dollar value" of two categories in a spreadsheet found by filtering the two categories and sum the column?

Posted March 9, 2021 1:49pm by Brittany Daniels

Brittany Daniels
512 Points
1 Answer
Christopher Cameron
741 Points
Unsure the type of answer format the question is seeking

Posted December 27, 2020 9:56pm by Christopher Cameron

Christopher Cameron
741 Points
0 Answers
Travis Carter
675 Points
I do not have the spreadsheet this question is asking for. How do I go about getting it.

Posted December 23, 2020 3:29pm by Travis Carter

Travis Carter
675 Points
0 Answers
Henry Spock
20,615 Points
Performing formulas on filtered rows/columns:

Posted December 1, 2020 4:45am by Henry Spock

Henry Spock
20,615 Points
0 Answers
Martin Svensen
6,738 Points
Hi. How do I format numbers correctly? For example, should 9431 be written just like that, or 9.431 or something else?

Posted August 10, 2020 9:24am by Martin Svensen

Martin Svensen
6,738 Points
1 Answer
Joshua Fredrickson
428 Points
Noticed an error

Posted August 5, 2020 7:56pm by Joshua Fredrickson

Joshua Fredrickson
428 Points
0 Answers
Kevin LG
5,640 Points
Am I entering my formula wrong to answer this question? Used "=SUM" after setting filters to F&B and Entertainment.

Posted July 31, 2020 11:26pm by Kevin LG

Kevin LG
5,640 Points
0 Answers
PLUS

Traci Leung
Courses Plus Student 2,534 Points
Where is the data for Store 34?

Posted July 9, 2020 6:05pm by Traci Leung

Traci Leung
Courses Plus Student 2,534 Points
0 Answers
Stephanie Albright
5,690 Points
The spreadsheet for this quiz is messed up and doesn't have store 34 on it.

Posted May 29, 2020 9:41pm by Stephanie Albright

Stephanie Albright
5,690 Points
2 Answers
Kawaljeet Singh
3,820 Points
Average

Posted May 7, 2020 2:00pm by Kawaljeet Singh

Kawaljeet Singh
3,820 Points
1 Answer
Christina Graves
310 Points
How do I reference particular cells while using filters?

Posted May 6, 2020 8:47pm by Christina Graves

Christina Graves
310 Points
1 Answer
rikael
1,856 Points
What function allows you to tell the minimum amount using two numbers not placed on a spreadsheet?

Posted May 2, 2020 6:16pm by rikael

rikael
1,856 Points
1 Answer

Prev Page 1 of 4 Next

Posting to the forum is only allowed for members with active accounts.
Please sign in or sign up to post.