CLICK HERE TO LEARN MORE ABOUT THE IMPRESSIVE COMPLETE EXCEL COURSE: https://lp.hashtagtreinamentos.com/es... -------------------------------------------------------------------- DOWNLOAD THE BASIC EXCEL MINI COURSE: https://pages.hashtagtreinamentos.com... BASIC EXCEL HANDBOOK [FREE DOWNLOAD]: https://www.hashtagtreinamentos.com/h... ----------------------------------------------------------------------- ► To Download the File Used in the Class, Access: https://pages.hashtagtreinamentos.com... ----------------------------------------------------------------------- If you prefer the video in text format: https://www.hashtagtreinamentos.com/f... ----------------------------------------------------------------------- TO HIRE HASHTAG FOR YOUR COMPANY: https://www.hashtagtreinamentos.com/t... ----------------------------------------------------------------------- Recommended Videos: ► The 5 FORMULAS Excel BASICS that you MUST LEARN before VLOOKUP • The 5 BASIC Excel FORMULAS that you MUST LEARN before VLOOKUP • The 5 BASIC Excel FORMULAS that you MUST LEARN before VLOOKUP • VLOOKUP - Complete Step by Step (without complications) • VLOOKUP - Complete Step by Step (without complications) ► Pivot Table - How to make an Excel Pivot Table in 5 steps! • Pivot Table - How to make a Pivot Table in... ► EXCEL SPREADSHEET to IMPRESS ANYONE • EXCEL SPREADSHEET to IMPRESS ANYONE ► Learn EVERYTHING about how to create GRAPHICS in EXCEL • Learn EVERYTHING about how to create GRAPHICS... ----------------------------------------------------------------------- Have you ever heard of the DSUMA function in Excel or any other DB function, such as DVAVERAGE, DMAX, among others? Today I want to show you the DBSUMA formula in Excel that will have the same function as the SUMIF and SUMIFS formulas in Excel, but in a simpler way. The acronym DB that comes before these formulas means Database, that is, they are formulas to be used in databases (or tables). So we can use them normally, but they end up being easier to use than SUMIF itself and will have the same result! ----------------------------------------------------------------------- Hashtag Treinamentos ► Subscribe to our channel: https://bit.ly/2O6A4RP ► Turn on notifications (click on the bell)! ► Like our video! ----------------------------------------------------------------------- Social Networks ► YouTube: https://bit.ly/2O6A4RP ► Instagram: https://bit.ly/2F7B6t4 ► Facebook: https://bit.ly/2UA4SwY ► Tik Tok: https://bit.ly/3dUpwkW To receive daily Microsoft Excel, VBA and Power BI content for free, join our Telegram group: https://t.me/joinchat/AAAAAFVJr0C7Il-... In our videos we teach several Excel tips and tricks in Excel so that you can develop and impress with this tool even if you have little or no knowledge of Excel! ----------------------------------------------------------------------- Class Content 00:00 Introduction 00:54 Presentation of the database 01:27 DBSUMA function in Excel 05:00 DBSUMA function with multiple criteria (sum with criteria) 06:34 Data validation in Excel 07:34 Other DB (database) formulas 07:57 DBMEDIA function in Excel 09:38 DBMAX function in Excel 09:55 Conclusion #excel #microsoftexcel #hashtagtrainings