Excel Is Fun

Excel Magic Trick 1188

January 18, 2016 0

SUMIFS with Wildcards to Do Approximate Criteria or “Fuzzy” Criteria DESCRIPTION See how use asterisk wild card to add all the cells that contain the word “Red”. SUMIFS with Wildcards to Do Approximate Criteria or […]

Dueling Excel

Dueling Excel 52

November 25, 2015 0

Lookup Two Criteria: SUMIFS, DGET, or Array Formula? DESCRIPTION See Mr Excel and excelisfun lookup a value given two criteria. You will see three formulas: SUMIFS formula, DGET formula, and an array formula that uses […]

Excel Is Fun

Excel Magic Trick 1174

November 2, 2015 0

Two Lookup Values For VLOOKUP? How Do I Do That? (6 Methods) DESCRIPTION See three methods for lookup situations where you have two lookup values: (00:10) What to do if you have two look values […]

Excel Is Fun

Excel Magic Trick 1171

October 22, 2015 0

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

Excel Is Fun

Excel Magic Trick 1149

August 6, 2015 0

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

Excel Is Fun

Excel Magic Trick 1127

April 27, 2015 0

DESCRIPTION See how to automate the tracking of and the Current and Ending Amounts for Budget Categories using The Excel Table feature, Data Validation drop-down list, the SUMIFS function, and Page Setup for printing. (00:08) […]

Excel Is Fun

Excel Magic Trick 1104

March 2, 2015 0

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

Excel Is Fun

Highline Excel 2013 Class Video 17

February 16, 2015 0

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

Excel Is Fun

Highline Excel 2013 Class Video 11

February 10, 2015 0

DESCRIPTION Topics in this video: (00:12) OR Criteria. (00:55) OR Criteria for counting with 2 COUNTIFS (03:40) OR Criteria that does counts and yields incorrect answer (don’t double count) (04:30) OR Criteria for counting with […]