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

New No-Code Track! 🚀 New videos dropping every week—start learning today!

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

✨ Earn college credits in Cybersecurity, JS, HTML, CSS and Python

  • Treehouse Logo
  • Plans
    Chevron
    • For Individuals
    • For Businesses
    • For Schools
    • For Libraries
    • For Military
  • Library
    Chevron
    • All Courses
    • Tracks
    • College Credit
  • Techdegree
    Chevron
    • Overview
    • Front End Development
    • Full Stack JavaScript
    • Data Analysis
    • UX Design
    • Python
  • Community
    Chevron
    • Community Projects
    • Live Sessions
    • Code Adventures
    • Discord
    • Forum
    • Success Stories
    • Treehouse Links
    • 100 Days of Code
  • Resources
    Chevron
    • Career Toolbox
    • CodeForward
    • Free Treehouse Near Me
    • Jobs
    • Blog
    • Support
    • About
  • For Individuals For Businesses For Schools For Libraries For Military
  • All Courses Tracks College Credit
  • Overview Front End Web Development Full Stack JavaScript Python Development Data Analysis UX Design
  • Community Projects Live Sessions Code Adventures Discord Forum Success Stories Treehouse Links 100 Days of Code
  • Career Toolbox CodeForward Free Treehouse Near Me Jobs Blog Support About
  • Sign In
  • Free Trial
Instagram Twitter Facebook YouTube LinkedIn
    • Newest
      • Newest
      • Active
      • Unanswered
      • Featured
    • All Topics
      • All Topics
      • • General Discussion
      • • AI
      • • Android
      • • APIs
      • • Coding for Kids
      • • College Credit
      • • Computer Science
      • • CSS
      • • Data Analysis
      • • Databases
      • • Design
      • • Development Tools
      • • Digital Literacy
      • • Game Development
      • • Go Language
      • • HTML
      • • Java
      • • JavaScript
      • • Learning Resources
      • • Machine Learning
      • • No-Code
      • • PHP
      • • Professional Growth
      • • Python
      • • Quality Assurance
      • • React
      • • Ruby
      • • Security
      • • Swift
  • Christopher Garavente
    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
    • Data Analysis
    • Spreadsheet Basics
    • Spreadsheet Functions & Shortcuts
    • Introducing Functions

    0 Answers

  • James Salgado
    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
    • Data Analysis
    • Spreadsheet Basics
    • Spreadsheet Functions & Shortcuts
    • Review Formulas and Basic Functions

    1 Answer

  • Ozaveshe Balogun
    seal-mask
    .a{fill-rule:evenodd;}techdegree
    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
    .a{fill-rule:evenodd;}techdegree
    Ozaveshe Balogun
    Front End Web Development Techdegree Student 20,459 Points
    • Data Analysis
    • Spreadsheet Basics
    • Spreadsheet Functions & Shortcuts
    • Review More Spreadsheet Functions

    1 Answer

  • nicolaspeterson
    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
    • Data Analysis
    • Spreadsheet Basics
    • Spreadsheet Functions & Shortcuts
    • The CHOOSE Function

    1 Answer

  • nicolaspeterson
    nicolaspeterson
    8,569 Points

    Can you select multiple criteria for a SUMIF?

    Posted October 20, 2021 7:44am by nicolaspeterson
    nicolaspeterson
    8,569 Points
    • Data Analysis
    • Spreadsheet Basics
    • Spreadsheet Functions & Shortcuts
    • The SUMIF Function

    1 Answer

  • nicolaspeterson
    nicolaspeterson
    8,569 Points

    Functions are not case-sensitive.

    Posted October 20, 2021 7:24am by nicolaspeterson
    nicolaspeterson
    8,569 Points
    • Data Analysis
    • Spreadsheet Basics
    • Spreadsheet Functions & Shortcuts
    • Introducing Functions

    1 Answer

  • Kim B
    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
    • Data Analysis
    • Spreadsheet Basics
    • Spreadsheet Functions & Shortcuts
    • The COUNT Function

    1 Answer

  • angiem
    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
    • Data Analysis
    • Spreadsheet Basics
    • Spreadsheet Functions & Shortcuts
    • Keyboard Shortcuts

    1 Answer

  • Christopher Cameron
    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
    • Data Analysis
    • Spreadsheet Basics
    • Spreadsheet Functions & Shortcuts
    • Review More Spreadsheet Functions

    0 Answers

  • rikael
    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
    • Data Analysis
    • Spreadsheet Basics
    • Spreadsheet Functions & Shortcuts
    • Review More Spreadsheet Functions

    1 Answer

  • Gilbert Rifkin
    Gilbert Rifkin
    3,116 Points

    Expenses

    Posted April 27, 2020 11:54am by Gilbert Rifkin
    Gilbert Rifkin
    3,116 Points
    • Data Analysis
    • Spreadsheet Basics
    • Spreadsheet Functions & Shortcuts
    • Review More Spreadsheet Functions

    1 Answer

  • Sahabi Choudhury
    Sahabi Choudhury
    1,943 Points

    Need urgent help with this question please!

    Posted June 16, 2019 9:04pm by Sahabi Choudhury
    Sahabi Choudhury
    1,943 Points
    • Data Analysis
    • Spreadsheet Basics
    • Spreadsheet Functions & Shortcuts
    • Review More Spreadsheet Functions

    1 Answer

  • Savious Munyaradzi Ngundu
    Savious Munyaradzi Ngundu
    16,920 Points

    Your boss asks you to tell her how many employees she needs to have on duty during an event. She needs at least 1 employ

    Posted February 26, 2019 6:14pm by Savious Munyaradzi Ngundu
    Savious Munyaradzi Ngundu
    16,920 Points
    • Data Analysis
    • Spreadsheet Basics
    • Spreadsheet Functions & Shortcuts
    • Review More Spreadsheet Functions

    1 Answer

  • Patrick Choulas
    Patrick Choulas
    2,828 Points

    sheets link not opening up

    Posted September 11, 2018 6:06pm by Patrick Choulas
    Patrick Choulas
    2,828 Points
    • Data Analysis
    • Spreadsheet Basics
    • Spreadsheet Functions & Shortcuts
    • The EDATE Function

    1 Answer

  • Jun Hyun Yoon
    Jun Hyun Yoon
    297 Points

    My goal ratio = 1 employees per 15 guests. 3,030 guests expected to come. =rounddown(3030/15,0) is it not correct?

    Posted July 19, 2018 3:12am by Jun Hyun Yoon
    Jun Hyun Yoon
    297 Points
    • Data Analysis
    • Spreadsheet Basics
    • Spreadsheet Functions & Shortcuts
    • Review More Spreadsheet Functions

    1 Answer

  • Nicolas Montoya
    Nicolas Montoya
    10,592 Points

    What is the answer is it not just =ROUNDDOWN(3030/15)?

    Posted June 21, 2018 12:44am by Nicolas Montoya
    Nicolas Montoya
    10,592 Points
    • Data Analysis
    • Spreadsheet Basics
    • Spreadsheet Functions & Shortcuts
    • Review More Spreadsheet Functions

    1 Answer

  • Miguel Enriquez
    Miguel Enriquez
    2,057 Points

    How to exclude Saturdays and Sundays while using EDATE?

    Posted April 2, 2018 5:08am by Miguel Enriquez
    Miguel Enriquez
    2,057 Points
    • Data Analysis
    • Spreadsheet Basics
    • Spreadsheet Functions & Shortcuts
    • The EDATE Function

    1 Answer

  • Anish Mathews
    Anish Mathews
    844 Points

    Your boss asks you to tell her how many employees she needs to have on duty during an event. She needs at least 1 employ

    Posted February 3, 2018 12:45am by Anish Mathews
    Anish Mathews
    844 Points
    • Data Analysis
    • Spreadsheet Basics
    • Spreadsheet Functions & Shortcuts
    • Review More Spreadsheet Functions

    1 Answer

  • syalih
    syalih
    16,468 Points

    Spreadsheets and Functions and Shortcuts Quiz 2?

    Posted July 31, 2017 9:11am by syalih
    syalih
    16,468 Points
    • Data Analysis
    • Spreadsheet Basics
    • Spreadsheet Functions & Shortcuts
    • Review More Spreadsheet Functions

    3 Answers

  • Sunitha Chilukuri
    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
    • Data Analysis
    • Spreadsheet Basics
    • Spreadsheet Functions & Shortcuts
    • Review More Spreadsheet Functions

    2 Answers

  • agzagi
    agzagi
    2,399 Points

    Why is it that when I select for the [sum_range] the whole C column, like C:C, it yields a totally different result?

    Posted June 16, 2017 3:12pm by agzagi
    agzagi
    2,399 Points
    • Data Analysis
    • Spreadsheet Basics
    • Spreadsheet Functions & Shortcuts
    • The SUMIF Function

    2 Answers

  • Renee Rhodes
    Renee Rhodes
    10,653 Points

    Quiz question, Formula keeps disappearing from Spreadsheet

    Posted April 22, 2017 4:15pm by Renee Rhodes
    Renee Rhodes
    10,653 Points
    • Data Analysis
    • Spreadsheet Basics
    • Spreadsheet Functions & Shortcuts
    • Review More Spreadsheet Functions

    2 Answers

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

    Treehouse

  • About
  • Blog
  • Careers
  • Community
  • Stories
  • Shop
  • Contact
  • Gift Card

See Full Catalogue

Techdegree

  • Front End Web Development
  • Full Stack JavaScript
  • Python Development
  • Data Analysis
  • UX Design

Tracks

  • Learn to Code for Beginners
  • Beginning Python
  • Beginning SQL
  • Beginning Java
  • ...see more

Courses

  • JavaScript Basics
  • Intro to HTML & CSS
  • Python Basics
  • CSS Layout
  • ...see more

Explore

  • Plans
  • Affiliates
  • Perks
  • Free Treehouse Near Me
  • Treehouse for Libraries
  • Treehouse for Businesses
  • Twitter
  • YouTube
  • Facebook
  • LinkedIn
  • Instagram
Terms & Conditions | Privacy

© 2025 Treehouse Island, Inc.