New Way to Sum Monthly Data into Quarters @MyOnlineTrainingHub
New Way to Sum Monthly Data into Quarters  @MyOnlineTrainingHub
Uploaded September 2023 | Updated November 2026, 4 days ago
How to sum monthly data into quarters using formulas. This video covers formulas suitable for all versions of
Excel, plus a dynamic array formula that spills the results for the entire table in one go.

⬇️DOWNLOAD the example file here: myonlinetraininghub.com/excel-formulas-to-summarise-monthly-data-into-quarters

🎓RELATED LESSONS:

BYROW & BYCOL Functions: youtube.com/watch?v=8-ANSpXcHr0
LAMBDA Function: youtube.com/watch?v=cGxjWOY8h98
WRAPROWS/COLS, V/HSTACK & TOCOL Functions: youtube.com/watch?v=oxXnc7jLe3U
PivotTable Grouping Alternative: youtube.com/watch?v=JXAz19poVek


LEARN MORE
===========

🏫 LEARN MORE in my Excel courses: myonlinetraininghub.com

📰 EXCEL NEWSLETTER - join 450K+ subscribers here: myonlinetraininghub.com/excel-newsletter-sign-up

🔔 SUBSCRIBE if you’d like more tips and tutorials like this.

📢 Please leave me a COMMENT. I read them all!

🎯 FOLLOW me on LinkedIn: linkedin.com/in/myndatreacy

🎁 SHARE this video and spread the Excel love.

Or if you’re short of time, please click the 👍

💬 EXCEL QUESTIONS: Get help on our Excel Forum: myonlinetraininghub.com/excel-forum


⏲ TIMESTAMPS
==============
0:00 The Problem
1:10 SUM fomrula - all versions
3:50 LET formula improvements
6:00 Dynamic Array Formula
11:05 Allowing for more rows & columns
New Way to Sum Monthly Data into QuartersSecret Excel Shortcuts That Arent on Any Cheat Sheet (But Should Be)Excel Personal Finance Tracker 101 | Build & Automate Yours in MinutesI Stopped Writing Process Docs After Finding This AI Tool (Scribe Demo)STOP Using VLOOKUP in Excel (Better Alternative)This One Function Does What Most Excel Users Can’t Figure OutThe Excel Trick I Use EVERY DAY (and you should too!)Hidden Formatting Tricks for SlicersDifference Between a Function and a Formula in Excel5 HIDDEN Excel Tools Almost Nobody Is Talking AboutThe Excel Combination I Use EVERY DAY (and you will too)The Excel Function You Should STOP Using (Alternatives)
MyOnlineTrainingHub |

New Way to Sum Monthly Data into Quarters

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER