Excel Forum
Similar Content
Simple Excel Function to Combine Values in All Versions of Excel - UDF
: Excel function that combines values from multiple cells or inputs using a delimiter - work...
Run a Macro when a User Does Something in the Worksheet in Excel
Tutorial: How to run a macro when a user does something in the worksheet, everything from selecting ...
Excel Function to Remove All Text OR All Numbers from a Cell
Tutorial: How to create and use a function that removes all text or all numbers from a cell, whichev...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course




Highline Excel Class 39: Forcing Functions To Become Arrays


If an array or range is put into a function argument that is expecting a single value, the function becomes an array and delivers an array of values instead of a single value. See these amazing tricks:
1)Count Unique values with SUMPRODUCT & COUNTIF functions array formula
2)Lookup Adding with SUMPRODUCT &SUMIF functions array formula
3)MEDIAN IF functions in array formula (calculating Median with conditions (criteria))
4)MAX IF functions in array formula (calculating maximum value with conditions (criteria))
5)MIN IF functions in array formula (calculating minimum value with conditions (criteria))
6)Adding (summing sum) top three values using SUM & LARGE functions with an array in array sytax
7)Conditional (criteria) adding & counting for dates with the TEXT & SUMPRODUCT functions
This is a beginning to advanced Excel class taught at Highline Community College by Mike Gel excelisfun Girvin Busn 214 BTech 109





Got a Question? Ask it Here in the Forum.