How To Get Monthly Totals From a Numbers Table
macmostvideo
0:00 / 0:00
How To Get Monthly Totals From a Numbers Table
11 702 просмотра · 1 год назад
macmostvideo
513 тыс. подписчиков
11 702 просмотра · 1 год назад
https://macmost.com/e-3305 When you have a table with dates in one column it is often useful to get subtotals for each month or other date ranges. There are many ways to do this using simple or complex formulas, table categories or pivot tables.
FOLLOW MACMOST FOR NEW TUTORIALS
▶️ Subscribe — https://macmost.com/j-youtube (And hit the 🔔)
🦋 Follow on Bluesky, Mastodon and more: https://macmost.com/social
FREE EMAIL NEWSLETTER
📬 See what's new each week and more — https://macmost.com/newsletter
📆 Per-Video Email Notifications — https://macmost.com/ytn
SUPPORT MACMOST AT PATREON
❤️ https://macmost.com/patreon
00:00 Intro
00:42 Select Cells For a Quick Sum
01:06 Using the SUMIFS Function
03:53 Using Table Categories
05:43 Using a Pivot Table
07:00 Using Array and LAMBDA Functions
#macmost #mactutorial