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
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










