REGEX() and SUMIF() - Check for multiple matches in Apple Numbers
HTML-код
- Опубликовано: 11 сен 2024
- How to use Numbers on a Mac
In this update to my SUMIF tutorial, I show you how to use the REGEX function within SUMIF in order to check for multiple matches.
Eg. If text is equal to A or B or C
This tutorial is useful for anyone learning about formulas in Numbers however it is aimed at beginners.
Check out my other tutorials for Apple Numbers:
• HOUR(), MINUTE(), and ...
• DAY(), DAYNAME(), and ...
• EOMONTH() function in ...
• EDATE() function in Ap...
• TODAY() and NOW() func...
• DATEVALUE() function i...
• DATEDIF() function in ...
• DATE() function in App...
• Create CHARTS in Apple...
• SUM(), SUMIF(), and SU...
Mac Numbers Function
#numbers, #apple, #spreadsheet, #spreadsheettutorial, #sumif, #regex, #tables
thank you for this, I am making my own business sheet and some of these explanations are very useful. Please keep teaching those formulas on youtube, I learn a lot from it. And I must say it’s very fun and learning experience. love this!!!! ❤❤❤
That's so great to hear! I'm glad you find them helpful. I have plans for many more. Thanks for watching!
Great use of Regex. Love the Numbers tutorials
Thanks! Glad you like them!
New to your channel and I really like the information and pace you use to present it. I am new to Mac from Windows and trying to make the transition from Word and Excel so any tutorials that would help me get comfortable with the basics would be great.
Thank you so much, I'm glad you're enjoying the videos. I have more videos planned for Pages and Numbers. Thanks for watching!
this was my next question LOL thanks a lot
Haha that’s great! Glad to have helped!
more tutorials of numbers ❤❤❤
I've got more in the works! Thanks for watching!
Another question, is there a way to find the lowest or highest number in a column? Could formatting be applied? Say a color. Can the formatting be made to change as the spreadsheet changes? For instance if a column had the numbers 10, 20, 30, 40, 50, high light the highest and/or lowest number, but if a new number, say 70 is added, the highlight for 50 would go away and move to 70? I suppose there are other things to have the spreadsheet look for.
Hmmm interesting question. Unfortunately Numbers only allows you to change the cell color base on that cell's value. you can't do conditional formatting based on other cell's values which is what you would need to do in this case (If I'm understanding your question correctly). Thanks for the question, and thanks or watching!
@@apple-a-day My son-in-law who is a longtime user of Excel said Excel could do what I had in mind. It's not anything I need to do, but it would be "useful" in a spreadsheet I keep of gas for the car. I'd like to highlight the highest and lowest I've paid for gas, highlight the best and worst gas mileage, etc. Thanks for your reply.