Quick Calculations In Mac Numbers

[@loisskiathitis8926]

Very useful and informative video tutorial today! Thank you, Gary! 👏🏻❤️

[@mikebaginy8731]

Wow, those functions are really nifty!

[@michaelhill6453]

I can't believe I've never noticed this. Brilliant!

[@socksistavideo7399]

thank you for this gary, it helps!

[@williamjohnson6245]

WOW...thanks Gary....I had no idea this even existed...very cool!

[@wardausman2795]

That was fabulous information, Gary! Thanks for sharing this.

[@johnphillips519]

Saved for later viewing as i often forget these tricks👍

[@josefhab8095]

very good, Gary. Thanks.

[@stephenbridges2791]

Very useful information. I knew about the drag and drop, but; I didn't know you could add other quick calculations. I'm always using Median then delete it after I find out what it is. I've written formulas that made my eyes water and my head hurt. Anything to make things quicker is cool in my book.

[@erinlarsen1261]

This was helpful! How do you figure out the Q1, Q3 and interquartile range?

[@macmost]

Depends on the situation and how you have constructed your spreadsheet.

[@hmaustips9742]

Another winner Gary! Thank you. Is there a way to add a specific calculation e.g. *1.04 to the calculations on the bottom? Or would the best way be to create a column that does that calculation first? And how do you use the And/Or?

[@macmost]

For specific calculations, just use normal formulas in cells, yes. For logical functions, see kzbin.info/www/bejne/anzHo2yabb-fbM0

[@hmaustips9742]

@@macmost Mahalo!! Another good one. Will share with our Mac club!

[@peazmo]

Great help Sir Gary! 🙏 Sir, is there a way to print the column and row headings of Numbers?

[@philippfolkerts6120]

What are you trying to do by printing?

[@Abdullah-zl9ub]

Watching your videos, im liking numbers a lot more than excel and wondering why its not used by most of people.

[@macmost]

I think it is used more on Macs than Excel. I mean it is free as opposed to having to buy Excel, which means most Mac users don't have Excel. But I don't know if anyone has any stats to back that up.

[@RELubber]

Because most people only know Excel. While it might take a bit of a mind shift to get comfortable with Numbers, there’s no way I’m paying a subscription to a program that’s 99% the same as it was 20 years ago.

[@ianh2674]

Very useful and good functionality

[@peterstubbs9558]

Thanks Gary

[@jessicamunday9377]

I'm not sure which video to watch to help me. I'm creating a weekly budget, but a lot of expenses are monthly or fortnightly etc. I'd like to create a formula (?) where by selecting the frequency of the expenses in a pop-up menu in one column (daily, weekly, monthly, quarterly... etc) it calculates the expense and gives me a weekly total or portion of in a new column. have you covered that in any past videos? Thanks!

[@macmost]

Maybe this is what you want? kzbin.info/www/bejne/gH68eX5re7-IoLc

[@jessicamunday9377]

@@macmost YES!!! that's it! thanks so much.

[@roryalbany3357]

Great video

[@desertpatient]

Thanks bunches

[@reallifelegend4781]

Hi Gary. Do you have any idea how to figure average costs of something when there are different quantities and differest prices each time? In Numbers, I have my spreadsheet currently telling me the total sum of the different quantities purchased over several months. And I've added the different prices over the months, and divided by the number of months. The problem is that that doesn't really give me the average paid since the quantities purchased each time were different. Instead, it only gives me the average price paid if the quantities purchased each time were all the same. I don't know how to figure the answer. And obviously, that means I don't know how to set it up in Numbers either. Any chance you might be able to help me with that?

[@macmost]

Just use math. Get the sum of the price totals, divide by the sum of the quantity.

[@bevintx5440]

Thanks! I had no idea that was there. Is something similar available for iPad Numbers?

[@macmost]

Yes. Look and see.

[@Abdullah-zl9ub]

Hello. I was going to ask same question. Ive just tested it on the numbers app in iPad however there is no row at the bottom of the app that shows the sum and average…etc. is there a way to show it up ? Or I guess it doesnt work on ipad.

[@bevintx5440]

I looked there before I posted the question. I just looked again, but I still don’t see it. Is there some configuration that I have to do befor I can see it?

[@macmost]

@@bevintx5440 Perhaps not then. I remember seeing these on the iPad, but perhaps I am mistaken.

[@tjmsyd6298]

If you select a range of cells in Numbers on the iPad and then choose ‘Cell Actions’ (or alternatively hit the green Cell button) then you can choose ‘Quick Formulas’ for Sum, Average, Minimum, Maximum, Count or Product. It will show the result in the cell at the end of your selection. There are 2 shortcomings: (1) you need to go back and delete the result in that cell if you only wanted to see the result temporarily; and (2) if the cell at the end of your selection was already populated then the result of the Quick Formula will overwrite it. A workaround for each of these is to simply hit the undo button in the top left hand corner.

[@elishaflores5643]

hello! Can you pls teach us how to use Z TEST under STATISTICS:( PLEASE I BADLY NEED AT SCHOOL :(

[@caterolla]

Muy útiles, gracias!!!

[@romansynovle990]

how do you get those numbers to show up at the bottom? i dont have that

[@macmost]

Perhaps you are using an old version of Numbers?

[@romansynovle990]

my mouse is seriously all over the place so it's not working yet. i cant seem to get anything other than a replication of the data i entered. maybe my settings is bad

[@mijaba71]

It's not quite right to say that Numbers is ignoring the headers for the calculations. It is ignoring text values. If you have a numeric value in the header, it will show up in the calculation.

[@macmost]

Interesting. If you put a formula like SUM(B) it will definitely ignore headers, even if they are numbers. But using Quick Calculations seems to be not using SUM(B) but SUM(B1:BX) instead.

[@mijaba71]

@@macmost I'm not quite sure what Quick Calculations are doing, but if you put a number in the header, it is included in the sum. If you have a mix of text and numbers, the text is ignored. My guess is that Quick Calculations is doing just what you showed: it's adding up everything that you select. There's definitely a lot more to the Quick Calculations than I knew about before watching the video. It's great just how natural it feels to use, at least most of the time.

[@nicolacursi9175]

how do you calculate p value?

[@macmost]

Not something I use, but a quick search says that the TTEST function is what you are looking for.

[@GMPO3]

I sure wish Numbers for iPad could do this.

[@otkur959]

Raqmet Gary!

[@Thesven100]

👍

[@RandomGiraffe4]

Thank you LEGEND!!!!!!!!!!!!