ADVERTISEMENT
Google AdSense Slot (headerLeaderboard)
Set your Publisher ID in src/config/ads.ts to display live ads.
Google Sheets & Cloud Spreadsheets Mastery• 5 min read
Core Calculations & Arithmetic Formulas
Learn essential spreadsheet formulas: SUM, AVERAGE, IF, SUMIFS, and string manipulation functions.
Core Calculation Formulas
Google Sheets operates in real-time in the browser. Every formula starts with an equal sign =.
| Formula | Purpose | Example Syntax |
|---|---|---|
| SUMIFS | Sum numbers matching multiple criteria | =SUMIFS(D2:D100, B2:B100, "Online", C2:C100, ">50") |
| COUNTIF | Count cells matching a condition | =COUNTIF(A2:A50, "Completed") |
| IFERROR | Catch calculation errors and provide fallback | =IFERROR(A2/B2, 0) |
| UNIQUE | Extract deduplicated unique values | =UNIQUE(A2:A100) |
ADVERTISEMENT
Google AdSense Slot (inContentBanner)
Set your Publisher ID in src/config/ads.ts to display live ads.
Test Yourself With Exercise
Which Google Sheets formula wraps another formula to prevent showing #DIV/0! or #N/A errors?