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: https://www.myonlinetraininghub.com/e...

🎓RELATED LESSONS:

BYROW & BYCOL Functions:    • 2 NEW Excel Functions ELIMINATE Copyi...  
LAMBDA Function:    • Excel LAMBDA Function: How & When to ...  
WRAPROWS/COLS, V/HSTACK & TOCOL Functions:    • 9 Exciting NEW Excel Functions for Sh...  
PivotTable Grouping Alternative:    • 3 PivotTable Grouping Tricks to Summa...  


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

🏫 LEARN MORE in my Excel courses: https://www.myonlinetraininghub.com/

📰 EXCEL NEWSLETTER - join 450K+ subscribers here: https://www.myonlinetraininghub.com/e...

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

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

🎯 FOLLOW me on LinkedIn:   / 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: https://www.myonlinetraininghub.com/e...


⏲ 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