Learn MS Excel Choose Formula can be used to apply multiple functions within a formula . In this video the choose formula has been used to apply 5 formulas 1. Sum
Formula 2. Average Formula , 3 Count Formula , 4 Max Formula , 5 Min Formula .
So how this works is as a user types 1 in the Index cell the sum of the values is done and if the user enters 2 in Index cell then the average of the values is done and so on. To understand this better, please click on the DOWNLOAD FILE link get a free a copy of the excel file shown in the video so that you can practice along the video : )
If you have any questions please do post them here and I will try to revert to them