Dueling Excel

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 Is Fun

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 Is Fun

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 Is Fun

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

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 >>>]

Dueling Excel

Dueling Excel 027

COUNT w More Than 1 Criteria 10 Examples! DESCRIPTION See Mr Excel and excelisfun use 10 different methods for counting with more than 1 criteria. See the functions: SUMPRODUCT w multiplying, SUMPRODUCT w double negative, [Read More >>>]

Excel 2013 PowerPivot Basics

Excel 2013 PowerPivot Basics 04

DESCRIPTION See two examples of Array Formulas and two examples of PowerPivot DAX formulas that count unique values in a column (Distinct Count) and compare and contrast: (00:09) Array Formula For counting unique values using [Read More >>>]

Excel Is Fun

Excel Magic Trick 1104

DESCRIPTION See how to add unit numbers with AND and OR Criteria where the criteria are given as years and months but date column contains serial number dates. See how to use SUMIFS function to [Read More >>>]

Excel Is Fun

Highline Excel 2013 Class Video 32

DESCRIPTION Topics in this video: 1. Essential definition of array formula: operation on an array of items rather than single items. 2. Example of operation on single items: subtracting 2 cells. 3. Example of operation [Read More >>>]

Excel Is Fun

Highline Excel 2013 Class Video 17

DESCRIPTION Topics in this video: (00:35) Bank Deposit Example: Multiply and then Add in Succession. (02:37) Grade Book Weighted Average Example: Multiply and then Add in Succession. (03:30) Accounting Budget Weighted Average Example: Multiply and [Read More >>>]