Treehouse | Community | Review Spreadsheet Calculations

🤑 Join the Treehouse affiliate program and earn 25% commission!

Join our Live Career-Building Workshop: Fast-Track Your Tech Career Without a Degree! ⭐ Register here!

🌟 Dreaming of a bright future? 🎓 Ask about the Treehouse Scholarship program! 🚀

Curious which AI tools Treehouse developers love? ⚙️ Check them out!

🫡 Treehouse for Military offers discounts to Veterans, service members and their families!

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

JOSEPH DOUCETTE
661 Points
how is my answer wrong? the total dollar value should be $11,061.00 if you sum all of column B values?

Posted August 14, 2024 7:16pm by JOSEPH DOUCETTE

JOSEPH DOUCETTE
661 Points
1 Answer
Lulu C
1,265 Points
Most expensive item: I’ve used the filter and sort options and I keep seeing 318 as the most expensive other item

Posted October 12, 2023 6:36pm by Lulu C

Lulu C
1,265 Points
1 Answer
Sean White
5,537 Points
We are taught how to sort, and how to filter, but not how to filter and then perform a function?

Posted July 27, 2023 6:28pm by Sean White

Sean White
5,537 Points
1 Answer
Sean White
5,537 Points
Based on this question, how do I know which field they are asking for? For example:

Posted July 27, 2023 6:09pm by Sean White

Sean White
5,537 Points
1 Answer
Ruth Browning
86 Points
The total $ amount of the F&B and Entertainment categories

Posted March 2, 2023 9:27am by Ruth Browning

Ruth Browning
86 Points
1 Answer
edwin echeverria
2,987 Points
In the Expenses spreadsheet you opened in the first question, the total dollar value of all items in the F&B and Enterta

Posted September 9, 2022 3:17am by edwin echeverria

edwin echeverria
2,987 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
2 Answers
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
Shakran Mushtaq
81 Points
Difference between formula and function?

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

Shakran Mushtaq
81 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
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
2 Answers
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
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
7,464 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
7,464 Points
1 Answer
Kevin LG
5,641 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,641 Points
0 Answers
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
Vikram Chan
Python Development Techdegree Student 281 Points
The spreadsheet shows ticket sales and revenue for a hypothetical theatre.

Posted April 14, 2020 10:40pm by Vikram Chan

Vikram Chan
Python Development Techdegree Student 281 Points
2 Answers
Lindsey Sheen
2,375 Points
I get $9,431.00 and I don't know if my answer is wrong because of the way its formatted or if the number is wrong.

Posted March 16, 2020 8:58pm by Lindsey Sheen

Lindsey Sheen
2,375 Points
1 Answer
Md Akibe Hashan
2,422 Points
i got stuck in this quize

Posted December 4, 2019 6:28am by Md Akibe Hashan

Md Akibe Hashan
2,422 Points
1 Answer
Sonam Shaikh
3,529 Points
This formula includes relative references to three cells

Posted July 18, 2019 4:19pm by Sonam Shaikh

Sonam Shaikh
3,529 Points
1 Answer
Tiffany Nichols
119 Points
When I download the examples spreadsheet its not the same as the videos. Am I missing something?

Posted July 12, 2019 11:11pm by Tiffany Nichols

Tiffany Nichols
119 Points
2 Answers
EMEKA PEACEWILL
Front End Web Development Techdegree Student 5,914 Points
how did you select all those data...just before going to the Data menu?

Posted July 8, 2019 10:08am by EMEKA PEACEWILL

EMEKA PEACEWILL
Front End Web Development Techdegree Student 5,914 Points
2 Answers
Sahabi Choudhury
1,943 Points
I need help on finding the answer to one of the questions in the quiz.

Posted June 16, 2019 6:34pm by Sahabi Choudhury

Sahabi Choudhury
1,943 Points
1 Answer
James Bachen
5,428 Points
Hi, I think this quiz is incorrect, or the joining spreadsheet is? Is there any help regarding this?? Cheers

Posted March 20, 2019 9:53am by James Bachen

James Bachen
5,428 Points
2 Answers
codyl
4,704 Points
If Excel is the most commonly used spreadsheet app -- why are lessons in google docs?

Posted January 2, 2019 10:15pm by codyl

codyl
4,704 Points
2 Answers
Mayank Tanwar
6,329 Points
What is the answer?

Posted December 15, 2018 8:07am by Mayank Tanwar

Mayank Tanwar
6,329 Points
1 Answer
livia salgado
4,407 Points
i really don't understand how to answer this question

Posted November 6, 2018 5:15pm by livia salgado

livia salgado
4,407 Points
1 Answer
George Hurst
1,610 Points
The total dollar value of the Entertainment and F&B Category 9431.00 is incorrect. How is this?

Posted November 5, 2018 3:48pm by George Hurst

George Hurst
1,610 Points
1 Answer
rsa14
1,865 Points
What does this question mean, absolute for all their rows and columns?

Posted September 11, 2018 6:45pm by rsa14

rsa14
1,865 Points
1 Answer

Prev Page 1 of 3 Next

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