### Dueling Excel 55

Calculate Grade & Exclude Scores When Student Is Absent DESCRIPTION See Mr Excel and excelisfun use SUMPRODUCT, ISNUMBER, and SUMIF functions to calculate a grade where excused absences are considered in final grade. WORKBOOKS

### Excel Magic Trick 1181

Formula to Count Cells with 4 or More Characters: COUNTIFS & SUMPRODUCT DESCRIPTION See how to: (00:08) Count numbers with 4 or more characters using COUNTIFS function. See that COUNTIFS requires Comparative Operators in Double [Read More >>>]

### Excel Magic Trick 1171

SUMIFS & SUMIF Treat 0500 & 00500 the Same! Use SUMPRODUCT Instead DESCRIPTION See how to add for Text Number Criteria such as 0500 and 00500 using SUMPRODUCT rather than SUMIFS or SUMIF: (00:08) Problem [Read More >>>]

### Dueling Excel 044

Count Mondays Between 2 Dates WEEKDAY or TEXT? DESCRIPTION See Mr Excel and excelisfun count the number of Mondays between two dates using the WEEKDAY function or the TEXT function wrapped around the ROW and [Read More >>>]

### Excel Magic Trick 1166

Count Dates From Date-Time Values: COUNTIFS or PivotTable? DESCRIPTION See how to Count Dates From Date-Time Values: COUNTIFS or PivotTable: (00:00) Look back to EMT 1163 to look at SUMPRODUCT and INT formula (00:45) COUNTIFS [Read More >>>]

### Dueling Excel 043

End Inventory Value From Transactional Records SUMPRODUCT SUMIF DESCRIPTION Mr Excel is on hiatus to finish his new Excel 2010 books. Excelisfun shows how to calculate Weighted Average Cost Ending Inventory Value from Transactional Records [Read More >>>]

### Excel Magic Trick 1163

COUNTIFS For Dates, When Dates Have Time Value Too? COUNTIF too. DESCRIPTION See how to: (00:10) COUNTIFS with Date Criteria that is matched up against a column with Data Times will not work. (00:55) Examine [Read More >>>]

### Excel Magic Trick 1156

Count with Two Conditions / Criteria From Non-Proper Data Set (2 Methods) DESCRIPTION See how to Count the āNā (New) and āUā (Used) for Each Sale (00:08) Problem Setup (01:08) Two COUNTIFS functions with Mixed [Read More >>>]

### Excel Magic Trick 1149

Dynamically Sum by Category without VLOOKUP Helper Column (2 methods) DESCRIPTION See how to: Dynamically Sum Costs by Category without VLOOKUP Helper Column: (00:47) VLOOKUP helper Column and SUMIFS function (03:10) Array Formula using SUMPRODUCT [Read More >>>]

### Dueling Excel 030

Count Bills for Money Transaction DESCRIPTION See Mr Excel and excelisfun create formula that will take a dollar amount and count how many \$100 bills, how many \$50 bills, etc. are needed for the minimum [Read More >>>]