Database Functions are similar to the *IFS functions, but much better.
👩🏫 Learn more about the Advanced Excel Formulas course: https://bit.ly/dfunctions24course
👩🏫 Master Excel with my courses: https://bit.ly/dfunctions24courses
⬇️ Download the example file and cheatsheet here and follow along: https://bit.ly/dfunctions24file
Imagine you're working with a massive spreadsheet and your boss asks you to sum up sales for a specific product, but only if it meets certain criteria. Oh, and they need it in the next 10 minutes.
Most Excel users would immediately reach for SUMIFS or PivotTables, but what if I told you there's a better way?
Database functions are little known gems that handle complex criteria effortlessly AND they’re not hindered by the limitations of SUMIFS and the other IFS functions.
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 Single criteria
2:23 Multiple AND criteria
3:45 Multiple OR criteria
4:44 Multiple AND & OR criteria
6:00 If you want to master Excel functions
6:46 Multiple OR criteria - different field
8:26 Wildcards
9:06 DGET function explained
#Excel #ExcelFunction #ExcelFunctions