Basic Excel - (Sumifs and Countifs) - Hindi
For Online Traning in Business Intelligence
Technologies - Excel, Power BI, SQL Server, Postgre SQL, Azure, Sharepoint, Tableau, SSIS Etc You can contact on below Contact Details
WhatsApp - +49 17636191639
Email - [email protected]
Syntax
• Countifs - is use to count with multiple conditions
• Syntax- Countifs(Criteria_Range1,Condition,Criteria_range2,Condition2) – Window User
• Countifs(Criteria_Range1;Condition;Criteria_range2;Condition2) – Mac User
• Sumifs – is use to sum value with multiple conditions
• Syntax - Sumifs(Sum_Range,Criteria_Range1,Condition,Criteria_range2,Condition2)- Window User
• Syntax - Sumifs(Sum_Range;Criteria_Range1;Condition;Criteria_range2;Condition2) – Mac User