Treehouse | Community | Review Spreadsheet Calculations

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
Finn Danson
122 Points
What is the value in cell E15?

Posted September 27, 2023 2:30pm by Finn Danson

Finn Danson
122 Points
1 Answer
Finn Danson
122 Points
Which row is the data header row?

Posted September 27, 2023 2:11pm by Finn Danson

Finn Danson
122 Points
1 Answer
Christopher Garavente
407 Points
Is there a way to sum ranges of cells - instead of entire rows or individual cells?

Posted August 2, 2023 11:44am by Christopher Garavente

Christopher Garavente
407 Points
0 Answers
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
McKay Montz
4,073 Points
Where is store 34?

Posted April 4, 2023 6:34pm by McKay Montz

McKay Montz
4,073 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
Maxim Culacov
7,374 Points
Since BEA website looks different now, I would like to request a link to be posted on a data set to be used

Posted July 1, 2022 11:05am by Maxim Culacov

Maxim Culacov
7,374 Points
1 Answer
James Salgado
739 Points
I can't seem to open/copy any of the links of the spreadsheet. So I can't answer questions. Unable to open any file

Posted June 2, 2022 10:58am by James Salgado

James Salgado
739 Points
1 Answer
charles bempah
1,295 Points
A I using the right function and am I using it properly?

Posted May 27, 2022 11:52am by charles bempah

charles bempah
1,295 Points
1 Answer
charles bempah
1,295 Points
5th question confusion.

Posted May 27, 2022 11:44am by charles bempah

charles bempah
1,295 Points
1 Answer
Ozaveshe Balogun
Front End Web Development Techdegree Student 20,459 Points
Hi. Please why is this equation wrong ? ROUNDDOWN(15*3030, 0).

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

Ozaveshe Balogun
Front End Web Development Techdegree Student 20,459 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
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
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
4,991 Points
Count Function - Google Sheet's... Help?

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

Kim B
4,991 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,548 Points
Links to US BEA and United Nations Statiscs are broken.

Posted April 2, 2021 8:07pm by angiem

angiem
1,548 Points
1 Answer
angiem
1,548 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,548 Points
1 Answer

Prev Page 1 of 5 Next

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

JOSEPH DOUCETTE

JOSEPH DOUCETTE

Lulu C

Lulu C

Finn Danson

Finn Danson

Finn Danson

Finn Danson

Christopher Garavente

Christopher Garavente

Sean White

Sean White

Sean White

Sean White

McKay Montz

McKay Montz

Ruth Browning

Ruth Browning

edwin echeverria

edwin echeverria

Maxim Culacov

Maxim Culacov

James Salgado

James Salgado

charles bempah

charles bempah

charles bempah

charles bempah

Ozaveshe Balogun

Ozaveshe Balogun

nicolaspeterson

nicolaspeterson

nicolaspeterson

nicolaspeterson

nicolaspeterson

nicolaspeterson

nicolaspeterson

nicolaspeterson

nicolaspeterson

nicolaspeterson

nicolaspeterson

nicolaspeterson

nicolaspeterson

nicolaspeterson

nicolaspeterson

nicolaspeterson

Veronica L

Veronica L

Maurice Moore

Maurice Moore

Shakran Mushtaq

Shakran Mushtaq

Kim B

Kim B

teodoro gonzalez

teodoro gonzalez

angiem

angiem

angiem

angiem