Рет қаралды 1,780
In this video, you will understand the proper use case for ByRow and ByCol functions that are now available in Production stage in MS Excel 365.
You will also learn the following:
- The correct syntax for these functions
- Calculating column or row wise sum, average or count of a dynamic array
- Wrapping the functions inside a super function ( SumArray)
- Introduction to Switch function
- Introduction to Advanced Formula Editor
- The underlying files is available for use in the following location:
www.profectusacademy.com/prac...
(item no. 4)