Treehouse | Community | The SUMIF Function

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

Join our Live Career-Building Workshop: Launch Your Tech-Adjacent Career! ⭐ 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

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
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
Alana Warson
5,296 Points
what current liability or current asset line item has the lowest book value in 2017

Posted March 26, 2021 9:14pm by Alana Warson

Alana Warson
5,296 Points
3 Answers
benjamind
6,442 Points
It seems that Google Sheets expects a semicolon instead of a comma as separator in the COUNTIFS function.

Posted January 8, 2021 5:31pm by benjamind

benjamind
6,442 Points
1 Answer
Melissa Kavanagh
2,283 Points
How can you use keyboard shortcuts on a Mac?

Posted December 8, 2020 5:06pm by Melissa Kavanagh

Melissa Kavanagh
2,283 Points
1 Answer
Jaron Trotter
11,472 Points
Can't read CSV files after I navigate to where my downloaded files are and I import pandas.

Posted November 4, 2020 12:30am by Jaron Trotter

Jaron Trotter
11,472 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
Cassidy Louch
2,175 Points
Value error when trying to merge the data frames

Posted December 2, 2019 2:09pm by Cassidy Louch

Cassidy Louch
2,175 Points
- Data Analysis
1 Answer
frankgenova
Python Web Development Techdegree Student 15,616 Points
How much data is missing from each row - what does axis = 1 mean?

Posted February 18, 2019 1:20am by frankgenova

frankgenova
Python Web Development Techdegree Student 15,616 Points
1 Answer
Murilo de Melo
14,456 Points
Filter applied, only the categories F&B and Entertainment selected, =SUM(B5:B176), result: $9,431.00. What's wrong?

Posted September 4, 2018 3:40pm by Murilo de Melo

Murilo de Melo
14,456 Points
2 Answers
Ricky Sparks
22,249 Points
In the Retail Network spreadsheet you opened in the fourth quiz question, the number of cells with a value of “TRUE” in?

Posted July 11, 2018 4:10am by Ricky Sparks

Ricky Sparks
22,249 Points
2 Answers
Mary Hunter
216 Points
The total value as I find it is $9,431.00, but the quiz is saying that's the wrong answer. What's wrong?

Posted June 2, 2018 10:41pm by Mary Hunter

Mary Hunter
216 Points
3 Answers
PLUS

Daniyell Augusta
Courses Plus Student 495 Points
The most expensive item in the "other" category is not Hair Salon?

Posted March 18, 2018 6:00pm by Daniyell Augusta

Daniyell Augusta
Courses Plus Student 495 Points
2 Answers
Kelly Burchfield
579 Points
I've been marked incorrect on a couple simple answers in this quiz. Is this a glitch perhaps?

Posted March 14, 2018 1:04pm by Kelly Burchfield

Kelly Burchfield
579 Points
2 Answers
Benoit Tordeurs
Full Stack JavaScript Techdegree Student 9,400 Points
Challenge SQL 2/3 delete the user with the username poley-hand from eCommerce database users/ bummer you did not delete

Posted December 26, 2017 8:47pm by Benoit Tordeurs

Benoit Tordeurs
Full Stack JavaScript Techdegree Student 9,400 Points
- Data Analysis
2 Answers
Benoit Tordeurs
Full Stack JavaScript Techdegree Student 9,400 Points
SELECT * FROM Model WHERE ModelID IN (SELECT ModelID FROM Car WHERE StickerPrice > 30000)

Posted December 24, 2017 3:19pm by Benoit Tordeurs

Benoit Tordeurs
Full Stack JavaScript Techdegree Student 9,400 Points
- Data Analysis
1 Answer
Noah Fields
13,985 Points
Why divide by 60 and then 24 instead of 1440?

Posted December 13, 2017 8:22pm by Noah Fields

Noah Fields
13,985 Points
9 Answers
Geo Gs
2,785 Points
how can i change he MODE format if im on excel i do not see the DURATION option

Posted December 6, 2017 3:34am by Geo Gs

Geo Gs
2,785 Points
1 Answer
Lidia Matzek
5,481 Points
Why is this not working:

Posted December 4, 2017 8:45pm by Lidia Matzek

Lidia Matzek
5,481 Points
2 Answers
Nicholas Mejia
23,800 Points
Not understanding why "A" is the median grade on the first quiz in section 2

Posted December 1, 2017 8:35pm by Nicholas Mejia

Nicholas Mejia
23,800 Points
- Data Analysis
1 Answer
jessicakelly
5,901 Points
I need help with my sql!

Posted October 24, 2017 2:58pm by jessicakelly

jessicakelly
5,901 Points
- Data Analysis
2 Answers
A X
12,842 Points
He lost me at absolute referencing...

Posted September 2, 2017 2:29am by A X

A X
12,842 Points
2 Answers
Kristy Knapp
10,632 Points
Google Sheets "Paste Special > Transpose" greyed out

Posted August 26, 2017 3:49am by Kristy Knapp

Kristy Knapp
10,632 Points
3 Answers
Cristian Gerardo Hernandez Barrios
28,382 Points
I don't undestand that question. I can't submit an answer

Posted July 26, 2017 5:18pm by Cristian Gerardo Hernandez Barrios

Cristian Gerardo Hernandez Barrios
28,382 Points
2 Answers
Martin Luckett
32,591 Points
More Big Data please

Posted July 23, 2017 1:20pm by Martin Luckett

Martin Luckett
32,591 Points
5 Answers
Sunitha Chilukuri
137 Points
USE THE SUMIF FUNCTION TO CALCULATE THE TOTAL EXPENSES OF F&B

Posted July 17, 2017 6:02pm by Sunitha Chilukuri

Sunitha Chilukuri
137 Points
2 Answers
STAFF

Craig Dennis
Treehouse Teacher
Looking for QA Volunteers for Introduction to Big Data

Posted July 13, 2017 4:47pm by Craig Dennis

Craig Dennis
Treehouse Teacher
- Data Analysis
5 Answers
John Tilton
2,243 Points
Right Answer is NOT Correct

Posted July 3, 2017 1:44am by John Tilton

John Tilton
2,243 Points
2 Answers
nfs
35,526 Points
Is the DATA ANALYSIS COURSE on Treehouse complete?

Posted June 29, 2017 7:53am by nfs

nfs
35,526 Points
- Data Analysis
4 Answers

Prev Page 25 of 33 Next

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