Thank you for your interest in Excel School program. Please watch this demo lesson to get a feel. If you like my style and want to learn more, sign up using the links below.
Conditional Summary Formulas
Most people would be familiar with simple formulas like SUM, COUNT and AVERAGE. But what if you need to calculate sum based on a condition (like total sales in region north for product categories printers & scanners)? You can use conditional formulas for that.What is in this lesson?
- SUMIFS, COUNTIFS formulas for conditional summaries
- Using operators like > < with these functions
- Calculating values between a range of dates
- Using wildcard operators like * and ? to match portions
Watch this lesson [33 mins]
Download the workbooks:
Download Workbooks for this lesson
Your teacher - Chandoo
My name is Chandoo and I will be your teacher in Excel School program. I have been training people on Excel, Power BI, Power Pivot and analytics for over a decade. My teaching is practical and hands-on with several real world examples. I have taught more than 20,000 people to date (online and offline) and I would love to help you. I live in coastal city of Wellington in New Zealand with my beautiful wife and two kids.
8 reasons why
- Step-by-step instruction
- 20 hours + video content
- 50+ Example workbooks
- 24x7 online access
- Download HD quality videos
- 2 years validity
- Secure classroom
- 30 day money-back guarantee
Big thanks...
I have subscribed for your online excel and dashboard lessons ( of course it has been some time) and was able to complete all the excel lessons. And these turned out to be very very useful in my work and made me very confident in excel reporting. A very big thank you to you for that 🙏😊
- Subhashini
- Subhashini