Step 2 of 4 · Google Sheets Essentials
=SUM(C2:C50) and a simple IF
=SUM(C2:C50) and a simple IF — step 2 of 4 in Google Sheets Essentials. Amount column, total at the bottom or a separate summary cell. =IF(C2>100,"check","ok") to flag big spends.
Free career skills tip: =SUM(C2:C50) and a simple IF (step 2 of 4 from "Google Sheets Essentials").
Amount column, total at the bottom or a separate summary cell. =IF(C2>100,"check","ok") to flag big spends.
Click the cell, don't guess ranges. Dollar signs later.
2 more paragraphs in this tip — free with a Learnlyst account.
Create a free account to read the full tip
Unlock “=SUM(C2:C50) and a simple IF” plus daily tips. Guides and course pages stay public for search.
From the full photographed course
Google Sheets Essentials →This tip is one step — unlock all 4 steps inside Learnlyst.
More Career Skills tips
Ready for the full Learnlyst library?
Free account for daily tips · $9/mo or $79/yr for every course.