If you think about advanced excel, dashboard automation, and logical and conditional formulas, you must be aware of excel mathematical functions #SUMIFS that were introduced in excel 2007. The SUMIFS function sum up cells that meet multiple criteria or conditions.
Syntax of SUMIFS
SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)
I have explained the basic things of this function in this video.
SUMIF Function👇
• SUMIF Formula in Excel in Hindi
**********************************************
Subscribe to YouTube & Follow on Facebook Page👇
/ exceluniverse
www.facebook.com/exceluniverse.in
Checkout Some Other Excel Tutorials Videos:
SUM Function👇
• Using the Sum Function in Excel | How...
How to use UNICODE and UNICHAR👇
• How to use UNICODE and UNICHAR
3D Lookup Formulas👇
• Excel 3D Formulas - Most Effective Fo...
Excel Chart Automation👇
• Excel Chart Automation
Extract Number From Text without VBA👇
• Extract Numbers From Text in Excel
Download Practice File Here 👇
https://mega.nz/file/Y7g2CICa#B6-4FqG...