An Introduction To Using Formulas In Mac Numbers

[@PGNogueira]

After many years with Windows Computer, I switched to an iMac. I stopped using Office and started exploring Pages and Numbers. These videos are a big help to me.

[@johnboyd7158]

Thank you Gary. I used Excel 25 years ago and now, in my 70's, I am relearning spreadsheets on a Mac. Very useful

[@diannbottomley3062]

As an older (70's) learner, I appreciated the easy to understand detailed explanations that you provide in order to learn how to create the desired results on what I'm trying to accomplish. You speak clearly and at a good pace so it allows me to stop the video to rewind it or practice implementing what you are saying very easily. Other educators put too many details into one video making it way too confusing to me. Your method of starting with the basics in one video, without going into too much detail, allows me to understand & remember what I've learned before moving on to the next level on the subject. Thank you so much!

[@Letsmakeitgreatagain.]

Ditto my friend! At 76 it take a lot more concentration etc.

[@kirkD9349]

I used Dell PC for 25 years. Finally got sick of it, with 2 mother boards replaced during the first year of a new Dell, and switched to Mac, and not going back. Wished I had switched earlier. Now I'm learning Pages, Numbers, and Keynote. Thank you for bringing me up to speed quickly!!

[@gregf9160]

You are a very good, accessible educator, Gary. I know all of this but you have made it accessible to people who may not understand spreadsheets in a really accessible way 👍 Thanks for all you do.

[@JBrakas]

EXCELLENT TEACHING! [From one teacher to another]

[@newleft2254]

You are so bloody good at explaining things. The vast majority of 'teachers' on here always talk from a place where they assume we must already know the most basic things but you don't do that, you explain it from the root to the branch. Thank you very much! This has helped me more than you could know! New subbie! New Like!

[@tomhammer1784]

You are able to learn, understand and simplify the various Apple software so profoundly. I find the easier than MS but you take it to the next level.

[@Carmine416]

I just found your page and am so grateful! I’ve been looking for simple concise instructions to use numbers and your video are incredibly helpful! Thank you for creating these to help us learn and use these tools more effectively 🙏🏼. You are sincerely appreciated!

[@peterc2248]

Man that footer row thing has blown my mind - I had no idea! Thanks a bunch Gary 🙂

[@a.taylor8638]

Thanks again, Barry. As a 75+er coming back after 6 weeks abroad without a computer, I found this invaluable (again!)! It's amazing what you forget at my age. You are so reassuring. Thank you.

[@andrewmack4830]

Brilliant. You are a great teacher. I have been doing spread sheets, both Numbers and Excel for decades (literally), and never knew about footer rows until I watched this video. Thank you. And you go at just the right speed

[@rohanwijesinghe8051]

Thanks so very much,finally i understand how to use this function. I am a senior citizen and new to use of spreadsheets. Really good explanation.

[@montanamask]

At 72 I have transitioned from PC to Mac and now am forced to forget Excel and learn Numbers! Thank you for this basic introduction that has allowed me to build my spreadsheets again! You made it an easy transition!

[@zaicy52]

Thank you for all the videos! They are all very helpful. I've used Macs exclusively for 30 years and wouldn't change, but I have never really used Numbers but after watching your video, I will. I learn so much from you.

[@fofa-xm1jo]

No words can express how thankful i am 😭 i hv to submit a work tmrw and ur video just saved me from days of working with these numbers 😭 thank you a looot

[@desertpatient]

Thanks bunches. I have Microsoft 365 subscription on my two iMac as I thought I would never learn to use Pages or Numbers...but thanks to you, I am learning. I am not renewing my 365 as I have Office 2016 on a PC laptop. Again, you have made the journey into Apple enjoyable. And again, I do enjoy your basics video and hope you never stop offering them.

[@LoveIsGrand00]

Wanted to make a spreadsheet budget for my family's overseas vacation this summer and had no idea where to start. This helped tremendously. Thank you!

[@petegreenfield8366]

That’s fantastic! Thank-you. That’s got me started. Not easy to figure out until someone shows you!

[@jimsdrumpageplus4050]

Very useful.Doing all of my entries for 1099 on my taxes for musical gigs and teaching in this.I should probably check out your courses.Thanks again.

[@jeanperren6094]

Hi Gary Thank you. I appreciate your time and effort presenting this excellent tutorial. That was just what I have been wanting to learn; a whole lesson dedicated to working on a specific project using pages. I am an experienced Microsoft Publisher user. As a teacher, I was able to make my own certificates and teaching resources. I have been struggling to learn Pages. It appears to be a combination of Word and Publisher but I continually come across difficulties and don’t know where to turn. What I learned today is that I can still do all that but will have some extras functions to use not available with Microsoft. Using styles and making templates, is a big plus and time saver. Again my sincere thanks for increasing my knowledge and confidence to continue learning to use pages.

[@boonchilla]

I wanted to come on here to say thank you so much for these videos! I am a brand new Mac Desk top user. Just bought my very first MAC computer and received it yesterday and I have to say you are an absolute God send! Thank you for your very helpful videos! I am a dog walker and I like to keep a track of the miles I do from each dog walk and this was EXTREMELY easy and helpful to someone who is not very technologically intelligent. HA HA or at least I didn't think I was! Now I feel like a badass getting to use this computer! Thank you again! :-). Happy new year!

[@debbyspagnol5274]

wow, I wish I would have found you sooner. You have a clear-sounding voice and I love the pace. I subscribed and look forward to watching more of your videos.

[@swiperlouie6857]

Wow, i dont know why I didn’t see basic tutorials for numbers. Great video, i learned so much!

[@themaddrummerofficial]

I'm so thankful I discovered your channel (after buying my Mac). I can't begin to tell you how much I've learned.

[@stewvlogs5084]

Thank you subbed and liked. Been using numbers formulae for many years. Changed jobs 5 years ago. Totally forgot how to even start a formula. Thank you I am starting to remember again.

[@magdap2868]

Thank you for this tutorial. Complete newbie to Numbers - never felt the need to know it until now :)

[@unstopology]

Are we just going to ignore the fact that Tom got an amazing deal? Great content. Learned a lot in one video.

[@jimbolic0809]

I LOVE this tutorial! Thank you so much for this simple walk through.

[@Vega_-bc2vq]

Thank you so much for sharing!!!!Incredibly helpful!!! 🙏🏼🙏🏼🙏🏼

[@pixelum2023]

Interesting once again. Today I learned about the footer row, something that doesnt exist in other spreadsheets like Excel.

[@elliemurphy5430]

I'm new to using numbers but have used excel since grade school. Thank you for this video, it helped me figure out how to do functions in numbers!

[@ilive4livemusic]

Great video yet again. As a rudimentary spreadsheet user I only know the most basic functions and tend to often do things in a more complicated and labor-intensive manner than necessary. TIL about footer rows. Many thanks for growing my knowledge so painlessly.

[@rasher009]

By far the most understandable tutorial

[@iAziz]

Thanks you so much Gary, I learned so much from you :)

[@antoniosousa_61]

Hi Gary, 1.000 likes to you. I worked with DOS > Windows > Office for the last 35 years and consequently I became addicted of Microsoft products. Now I decided to jump in to the Apple's ecosystem and I'm really well surprised. Thanks to your tutorials I'm learning really fast this environment - I'm seeing all of your videos. Thank you very much to you Again, 1.000 likes to you. Regards, António

[@mindyleishman2997]

Thank you! Exactly what I needed! Simple, easy to follow instructions :)

[@RickPaquin]

As others have commented, you have a serious gift for teaching. Using Numbers is also a dream. I had previously used a competitor's product for 20 years, pulling my hair out when it came to formulas, but after watching your video, I was off any running, and it was fun! Thank you so much for your time on this. All of your video's are outstanding.

[@manishthakkar7126]

You explain so well, i really would like to learn more. Thank you Sir.

[@anuragtripathi2225]

Proper and easy explanation. Thank you

[@loisskiathitis8926]

A very informative video tutorial today! Thank you, Gary! 👏🏻❤️

[@lauraleacollet7361]

AWESOME! I learned this years ago and now needed a spreadsheet. I think I tossed my notes-yikes. This got me going! Thanks for making it easy!

[@oldblokeinwales]

As others have said you are a great teacher. I am 85 years old and I find I need to use a simple spreadsheet for my money accounts for the home. Thank you for your clear and concise explanations. John.

[@okanagansawmill]

Hey Gary thanks for this video helped me get a basic business income and expenses sheet setup!

[@carolinehodder1224]

Thank you. So easy to understand - this was exactly what I was looking for 😊

[@waltons-crochet]

Great instruction for a newbie. Thank you so much.

[@carlenehomer2431]

Thank you so much!!! You are a total life saver!

[@luiscastro1396]

Gary im 100% agree with ALL positive comments from those folks that what your educational video 👍👍

[@IRVremy]

I wish and hope that Gary knows just how AMAZING he is!

[@kathybrandenburg2338]

I absolutely love your videos! You are my Mac education go to😀

[@williamjohnson6245]

Thanks Gary...appreciate all that you do!

[@Lucy-vq8sn]

thank you so much! so hard to find any useful help in the application

[@ropsnikropsnik2327]

I really like your Numbers videos. It took me a while to convert from Excel to Numbers and your videos have made this transition easier. Thank you!

[@chelsariel]

Great tutorial! Thank you for sharing!

[@Abbasfathy]

I have a column with a checkboxs (range b1:b5) and another column (range c1:c5) and I want to count the checkboxs if true in the same time the column (range c1:c5) should be empty (with no values). So, the formula will count the checkboxs (b) which the column (c) in empty. Your HELP is great. Thank you!

[@macmost]

Sorry, not following you there.

[@Abbasfathy]

@@macmost This is was UN-expected reply from a big instructor like you! The instructor should be cooperative with people who are asking for solving a problem in the same field. Anyway I got the answer from another best channel and I recommended them to Apple Society because they solved my problem. The macmost... will not be my channel anymore.

[@macmost]

@@Abbasfathy Sorry, I don't know why you would say that. I couldn't follow your initial question. Was looking for clarification. Should I not have asked for clarification? What would have been the proper response in your opinion considering I read your question and wasn't sure what you were asking?

[@aliamirshah4322]

This video helped me so much thank you 🙏

[@avinashmv9686894578]

That was helpful. Thank you.

[@GrahamGphotoParker]

What a great instructional video. Is there anyway of reading a spread sheet with formulas in it and locking the formula so that they can't accidentally be deleted or changed. I don't find this is an issue on a MacBook but do on an iPad when entering data

[@macmost]

You can only lock tables, not individual cells. So you'd need to design your document with data inputs in one table and locked formulas in another table.

[@RobertFKleinberg]

Thank you for this video. Better than Apple explanations.

[@RenoFencingMan]

This was fantastic! Thank You!

[@tomhammer1784]

I retired 12 years ago after having to use MS apps for many years. What many do not know is that a few years be before retiring I did most of my work,on my Powerbook and iMac and then converted them to MS format to use on my windows machine at the office. That God for USB thumb drives.

[@Cedarsea]

really enjoy your tutorials

[@beverleypeacock]

Yay..finally found what I am looking for..I'll have to tell U2 all about it. 😎

[@travisburch4342]

Awesome job on this video, friend.

[@george12265]

Thanks, helped me a lot!

[@Unli17]

Thank you its basic but its really informative

[@sueperkins3258]

This was excellent

[@davestoneband]

Thank you very much. Fantastic tutorial video

[@thebiglebron50]

very useful thank you so much

[@thelemleys]

Amazing thank you am learning so much from you ....thank you

[@OmarFarooq-s3w]

Gary, another great tutorial from you. Keep it up. Is there any way we can link our eTrade account and portfolio to Numbers which will help to review it from Numbers. This will help to use the regularly updated Portfolio with various Number functions. Yahoo finance allow to link eTrade and thought may be Mac also has some option to link / import portfolio from eTrade

[@macmost]

No, there's no easy way to do that. I'm guessing ETrade has some sort of download function where you could get a CSV, but it would be a one-time download and nothing "linked."

[@AnthonyLongo-jg4uj]

Can you do this with a template ? I do not see the same things when I use the invoice that my Mac has... Thanks

[@jackcave3943]

i love your pace.

[@Kowslayer]

man's out here doing God's work even though no one asked for nor deserved it.

[@mahidertihtina4852]

Great video!

[@kamilosieglewski]

Hi Gary, how to change the options there so it doesnt round the numbers up? I need to be more accurate within the "budget" template.

[@ClaudiaConnor]

Can you please show how you're repeating the process for all the names? Or do I have to insert the formula for all 10k names I want to combine? TY!!

[@macmost]

You can copy and paste formulas. I show that in the video.

[@yogabirdco4311]

Soooo helpful. Thank you!

[@Justkicks4me]

If you highlight the cells it adds it up for you too without the plus sign.

[@Creative-jg6gq]

What is the formula for entering the next numeric value in a column ? For e.g: If I have a column that needs to be 1, 2, 3, etc can I do this with a formula instead of typing the numbers for each column?

[@macmost]

The main way you would do that is with autofill. See kzbin.info/www/bejne/r5i5i4x7rK58oKc

[@benjaminlewiscpt]

Thank you SO much.

[@sparkplug964]

Nice video, cheers

[@swaha55]

Hi Gary, Is there any way to create a formula on a spread sheet that has a column with a running total as each new row is added? I want to track my mileage and I have one column with date, one column with Job, one column with Miles and then a total in the footer but I want to have another column that keeps adding the previous totals as I enter data so I can see how many miles I drove in a month or a week.

[@macmost]

Yes. Do exactly that. So if column E is miles, then F can be a running total. F2 would have SUM(E$2:E2) so then when you put that same formula in F3 it would be SUM(E$2:E3) and so on. The $ is notation for "Preserve Row/Column" which you can set by clicking on the reference in the formula.

[@swaha55]

@@macmost Thank you. Does this mean I need to enter the SUM(E2:E3) in every row of the column that will have the running total?

[@macmost]

@@swaha55 No. Copy and paste. If you copy SUM(E$2:E3) from F3 and paste it in F4, you should get SUM(E$2:E4). Try it and see.

[@bobswitzer4384]

I was surprised you didn't mention using the yellow dot that appears at the bottom of the selected formula cell to drag the formula down several rows in the column. It's quicker than copying, shift-clicking the cells and then pasting.

[@macmost]

Because that, and a lot of other techniques like it, just confuse things when you are dealing with "An Introduction To..." video. Got to keep it simple. You can easily add those shortcuts and tricks later on, after you understand how formulas work.

[@bobswitzer4384]

@@macmost That makes sense. Thanks for explaining the reason.

[@MREASTSIDEGRIDE]

Can we input formulas in drop down menus? I want to use drop down options to that reference other cells

[@macmost]

No way to do that.

[@harryhellerman474]

Thank you for showing me how to move the formula box.

[@ba0700]

I am trying to use the IF function to say if the value in a certain column = 0.00, then the value in another column will =0.00 The particular column also has another = function in it. Could anyone show me how to do that?

[@brenttownsend2554]

Is there a syntax for finding the difference between 2 values? I think I remember using something like =dif ....etc years ago but it doesn't seem to work anymore. While I can type out (for example) B2-G2, it's kinda awkward. Just asking...

[@macmost]

Subtracting them is the way to find the difference. If you want an absolute value, put the ABS function around it.

[@Jason-yo8nk]

Hi Gary, how to sum the same cell across multiple sheets in mac numbers as a formula? thanks

[@macmost]

You can use INDEX or INDIRECT for that. kzbin.info/www/bejne/iIepiYatjcaJl7c

[@kennethcooper5717]

How do you calculate a row of numbers to show the balance at the end of the row if you know what your balance is? Example: If I enter a number of cost, let's say 7 columns that indicate payments. I want the end of the row to show what balance is left. Thx

[@macmost]

Depends on how you have it set up. If you have a column that is "deposits" and other that is "withdrawals" then you take the value from the balance in the row above, add one and subtract the other. Repeat for each row.

[@milesbrown2]

Hey Gary. I appreciate your contribution of knowledge towards helping us novices. A question- if I insert a value into a cell, then I want the next cell below it to show an amount 5% higher than that number, how would I create that formula? I’ve tried B3+5%, but obviously it doesn’t work. I’d appreciate any advice. Thanks🤔😵‍💫 This just in… a friend advised me to try (B3)*1.05. It worked so I’m good to go. Thanks.

[@macmost]

Nothing complex, just basic math: you multiply by 1.05.

[@CapsLock33]

with power cost going up. Can you please make a video on a day to day electricity usage calculator?

[@macmost]

Not sure what you'd want in a tutorial on that. Just keeping track of your bill?

[@johngriffin7071]

Hello Gary, hoping you can point me in the right direction. Loved your video on Numbers Budget and I like the person budget template but the one transaction sheet for a year is over wielding, so I want a transaction sheet for each month. I've tried adjusting the formula to accommodate that but just end up with the dreaded red triangle in my cells. Can you point to to another of your videos or other help. Thank you.

[@macmost]

I wouldn't do transactions-per-month. Keep it all in one table. Dividing your transactions into months makes it very hard to do calculations on them. Just have one table with all of your transactions, with one per row. Filter if needed. Use pivot tables if needed. As for errors in formulas, it is just a matter of looking at the error message, then looking at your formula and making adjustments. There's no one-size-fits-all solution to correcting mistakes. You need to assess, plan, try things out, repeat.

[@johngriffin7071]

@@macmost thank you very much. I will take your suggestion and use either filter and or pivot tables. Thank you .

[@marcbeattie4484]

Thank you mate

[@anamimuwal]

Hi Gary i am trying to convert decimal time to hh:mm in numbers. I would really appreciate if you could help me out with this. Thank you

[@macmost]

What do you mean exactly? First, do you mean date and time, or do you mean duration? If duration, then do you mean you want 5.5 converted to 5h 30m?

[@angelitoore1]

Good video! Please how can i do as a macro in Numbers? Can i do a data form?

[@macmost]

Numbers doesn't do forms on the Mac. Not sure what you are trying to do "as a macro."

[@angelitoore1]

I want to do an automated data entry form like excel macros without coding Thanks

[@stevehenkel354]

I'm new to Numbers. What am I doing wrong? Entering "=" doesn't put me into a formula mode it just thinks I'm entering the character "=" as part of my data. Entering any cell references after that are also treated as just data. (After I wrote the comment above I tried it the manual way you mentioned at the beginning (insert/formula/etc.) and it worked. Now, every time I enter a "=" it starts a formula. Is it normal that you have to use insert/formula the first time?)

[@macmost]

Not sure what you were experiencing there. Pressing = with a cell selected should just take you into formula entry mode. Glad it is working for you now.

[@SwitchShield]

guys I am really struggling with a project on numbers, I need a drop down menu to populate one of three numbers dependant on certain sequences of answers chosen by 6 other drop down menus

[@deniz3273]

Great video

[@tommygerald957]

Is it possible to make a title for a footer cell with where the text is aligned left and the number is aligned right?

[@macmost]

Not sure what you mean. A cell contains a single value. So you would have one cell with text, and other cell with a number.