skinny.

Latest / ModeLoop: Financial Modelling in Excel

SUMIF, SUMIFS & COUNTIF in Excel for Financial Models (P2E7)

Stop totalling rows by hand. This lecture covers SUMIF, SUMIFS, COUNTIF, COUNTIFS and AVERAGEIFS, the conditional aggregation functions every financial modeller uses to build budget summaries, ageing reports and model integrity checks.

In this episode:

SUMIF for single-condition totals

COUNTIF for counts and integrity checks

SUMIFS and COUNTIFS for multiple criteria

Date criteria and wildcard matching

Budget summaries and ageing analysis

📖 Full blog post: https://modeloop.net/Blog/P2E7-Summarizing-Data-with-SUMIF-COUNTIF-and-SUMIFS

📺 Watch the video lecture: https://youtu.be/3mOjlh5YPfs

🎓…

Log in to save or queue this episode.

The skinny

The skinny isn't ready yet — notes appear once the transcript is processed.