Sum Average Problem

Input a series of integers, the first integer is special, as it indicates how many integers will follow. Program should calculate and print the sum and average of the integers. Use a For-Next loop  in the code to solve this problem.

 

Create a flowchart and VBA code to solve this problem. Create a command button on the spreadsheet named cmdSumAverage. Place the code under the Click event of a command button titled “Sum Average”.

Flowchart Solution

Sample Screen Shots

VBA Solution Code