Hello,
I am working on a worksheet with thousands of columns. The columns alternate between salary and quantity. I need to place the sum total for each salary column on row 51 and the average for each salary column will be calculated by dividing the sum of each salary by the number of salaries found on row 50, for each salary column (they start at column L). The average will be placed on row 52 for each salary column (every other column). Here is a picture for clarity:
I am working on a worksheet with thousands of columns. The columns alternate between salary and quantity. I need to place the sum total for each salary column on row 51 and the average for each salary column will be calculated by dividing the sum of each salary by the number of salaries found on row 50, for each salary column (they start at column L). The average will be placed on row 52 for each salary column (every other column). Here is a picture for clarity: