Getting Started with Numbers on Mac: Lesson 5 - Basic Formulas

<p>Gaurav is back with the next installment in our Numbers tutorial series, diving into one of the most essential spreadsheet skills: the <strong>SUM function</strong>. Whether you're tracking expenses or organizing data, learning to total values quickly is a must.</p><p><strong>Quick Guide: Summing Your January Expenses</strong></p><ol><li><strong>Select the Cell</strong> – Click the cell where you'd like the total to appear.</li><li><strong>Start the Formula</strong> – Type <code>=</code> and then <code>SU</code>. Use the arrow keys to highlight <code>SUM</code> and press <strong>Enter</strong>.</li><li><strong>Set the Range</strong> – Type your cell range, like <code>B2:B5</code>, and close with a <code>)</code>.</li><li><strong>Finish</strong> – Hit <strong>Enter</strong>. Boom—your total is ready!</li></ol><p><strong>Want to Make a Change?</strong> Just press <strong>Option + Enter</strong> to jump into the formula editor, tweak your formula, and press <strong>Command + Enter</strong> to apply it.</p><h3>Introduction to Basic Formulas</h3><ul><li>Learn how to analyze and manage data with formulas</li><li>Focus: Using the <strong>SUM</strong> function to total values easily</li></ul><h3>Using the SUM Function</h3><ul><li>Adds up all values in a defined range</li><li>Common use: Insert a “Total” row to sum a column’s data</li><li>Enter the function where the total should appear</li></ul><h3>How to Enter the SUM Formula</h3><ul><li>Navigate to the desired cell</li><li>Press <strong>Option + Enter</strong> to begin editing</li><li>Type <code>=</code> to start the formula</li><li>Enter <code>SU</code>, then select <code>SUM</code> with the arrow keys</li></ul><h3>Inserting the Formula Example</h3><ul><li>In cell <code>B6</code>, type: <code>=SUM(B2:B5)</code></li><li>Press <strong>Enter</strong> to apply and see the result</li></ul><h3>Editing a Formula</h3><ul><li>Click the Total cell</li><li>Press <strong>Option + Enter</strong> to enter edit mode</li><li>Use arrow keys to move around and edit</li><li>Press <strong>Command + Enter</strong> to save changes</li></ul><h3>Pro Tips</h3><ul><li>Use larger ranges for more data, like <code>B2:B1000</code></li><li>Press <strong>Option + Enter</strong> anytime to reopen the formula editor</li><li>Arrow keys let you fine-tune your formula line-by-line</li></ul><p>Spreadsheet skills made simple—with Numbers on your Mac!</p><h3>Transcript</h3><p>Disclaimer: This transcript was generated by <a href="https://apps.apple.com/us/app/ai-note-taker-voicepen/id6462815872">AI Note Taker – VoicePen,</a> an AI-powered transcription app. It is not edited or formatted, and it may not accurately capture the speakers’ names, voices, or content.</p><p><strong>Gaurav</strong>: okay folks so in this lesson we are now going to get into very basic formulas and formulas are very easy yet powerful methods of analyzing and playing around with our data. So today I'm going to use probably one of the most used function, which is the sum function. So it is a way of totaling all the values in a set of cells.</p><p><strong>Gaurav</strong>: So what we're going to do is, again, jump back into our table.</p><p><strong>Gaurav/VoiceOver</strong>: Food. Rowhead or cell? Cell. water row header cell transportation row header cell internet row header cell row header cell cell okay so we have all of our headings in the category headings in column a internet row…</p>