Highline Excel Class 39: Forcing Functions To Become Arrays





The interactive transcript could not be loaded.



Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Published on May 13, 2009

Download Excel file: http://people.highline.edu/mgirvin/ex...

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

  • Category

  • License

    • Standard YouTube License


When autoplay is enabled, a suggested video will automatically play next.

Up next

to add this to Watch Later

Add to

Loading playlists...