E2fx=SUMIF(B2:B7,"West",C2:C7)
ABCDE
1OrderRegionAmountWest
21001West120225
31002East75
41003West60
51004South200
Correct. Your formula returns 225.

What you'll learn

    Built for the work you do

    Curriculum

    Taught by someone who used it on the job

    PricewaterhouseCoopers

    Audit. Where Jim learned what large models and macros can do to cut manual work.

    London Business School

    MBA. Coursework built on spreadsheets and statistical models.

    Google

    Worked with small businesses and startups, and became the go-to Sheets help for colleagues.

    Earn the certificate

    TeachMeSheets Certificate

    Level 1

    Google Sheets Basics

    Awarded to Your Name

    Final exam, 80% to passJim Murray, Instructor

    Each level comes with a shareable certificate page and a credential ID. One click adds it to Licenses & certifications on your LinkedIn profile. Preview yours.

    Pass all three levels to complete the full certificate.

    Questions

    Do I need to install anything?

    No. Practice happens in a live spreadsheet right in your browser. For the reading lectures, a free Google account lets you follow along in your own sheet.

    What if my formula is different from the answer?

    That's fine. The grader checks what your formula calculates, so any approach that gets the right answer counts. Some lessons ask for a specific function, and those say so up front.

    Does this work for Excel too?

    Mostly. Well over 90% of the formulas here work the same in Excel. Sheets-only features are labeled.

    How does the certificate work?

    Each level ends with a final exam. Score 80% or higher and you can claim a verified certificate for that level, with its own page and credential ID. Certificates come with the Certificate Pass.

    Can I buy this for my team?

    Yes. Pick a number of seats on the pricing page, pay once, and share one invite link. You see everyone's progress and exam results on your team page.

    Training a team?

    Seats from $59 each, one invite link, and a progress report for every person. Most teams are set up in five minutes.

    See team plans

    Your first formula takes about two minutes.

    Start Level 1 free