These SUM Tricks Will Blow Your Mind (No, Seriously)
SUM isn't only for totals, it can also handle COUNTIFS, SUMIFS, OR logic, and conditional averages.
👩🏫 Go deeper with the Advanced Excel Formulas course: https://bit.ly/sum25course
⬇️ Download the example file here and follow along: https://bit.ly/sum25file
Ah, SUM. The first formula we all learned. It’s great for adding up columns and rows, but what if I told you SUM can actually do the job of COUNTIFS, SUMIFS, even AVERAGEIFS without switching functions? In fact, it can also overcome the limitations of those functions. Surprised? There’s more, so let’s get started!
LEARN MORE
===========
📰 EXCEL NEWSLETTER - join 450K+ subscribers here: https://www.myonlinetraininghub.com/excel-newsletter-sign-up
🎯 FOLLOW me on LinkedIn: https://www.linkedin.com/in/myndatreacy/
💬 EXCEL QUESTIONS: Get help on our Excel Forum: https://www.myonlinetraininghub.com/excel-forum
⏲ TIMESTAMPS
==============
0:00 SUM replacing COUNTIFS
5:38 SUM replacing SUMIFS
7:11 SUM replacing AVERAGEIFS
9:41 SUM searching inside text
11:47 This function does what most users can’t figure out
#Excel #ExcelFunctions #ExcelFormulas
Видео These SUM Tricks Will Blow Your Mind (No, Seriously) канала MyOnlineTrainingHub
👩🏫 Go deeper with the Advanced Excel Formulas course: https://bit.ly/sum25course
⬇️ Download the example file here and follow along: https://bit.ly/sum25file
Ah, SUM. The first formula we all learned. It’s great for adding up columns and rows, but what if I told you SUM can actually do the job of COUNTIFS, SUMIFS, even AVERAGEIFS without switching functions? In fact, it can also overcome the limitations of those functions. Surprised? There’s more, so let’s get started!
LEARN MORE
===========
📰 EXCEL NEWSLETTER - join 450K+ subscribers here: https://www.myonlinetraininghub.com/excel-newsletter-sign-up
🎯 FOLLOW me on LinkedIn: https://www.linkedin.com/in/myndatreacy/
💬 EXCEL QUESTIONS: Get help on our Excel Forum: https://www.myonlinetraininghub.com/excel-forum
⏲ TIMESTAMPS
==============
0:00 SUM replacing COUNTIFS
5:38 SUM replacing SUMIFS
7:11 SUM replacing AVERAGEIFS
9:41 SUM searching inside text
11:47 This function does what most users can’t figure out
#Excel #ExcelFunctions #ExcelFormulas
Видео These SUM Tricks Will Blow Your Mind (No, Seriously) канала MyOnlineTrainingHub
Mynda Treacy My Online Training Hub Microsoft Excel Excel SUM in excel sum in excel formula sum in excel function sum function excel sum function in excel sum formula sum formula in excel what sum can do in excel sum tricks excel sum excel tricks sum tricks in excel averageifs alternative excel functions excel functions tutorial excel formulas excel formulas and functions sumifs alternative countifs alternative sumifs and countifs in excel
Комментарии отсутствуют
Информация о видео
27 мая 2025 г. 16:45:03
00:12:10
Другие видео канала
