Question

4. Write a sub that computes the averages for each two rows (Jan and Feb) of a table where the data starts in cell B1 on worksheet “Operations” and there are five years worth of data in each row..
   1. Store the average at the end of each row. (NOTE this is shown in the example table below)

Customer ID	1001	1002	1003	1004	1005	Row Average
Jan	10	20	14	15	18	15.4
Feb	12	22	13	16	19	16.4

Answer 1

The average can be computed using the Average excel function.

Customer ID	1001	1002	1003	1004	1005	Row Average
Jan	10	20	14	15	18	15.4
Feb	12	22	13	16	19	16.4

WORKINGS