Sum each column and then perform average, place amounts on designated row for column

[Pandrade]

Hello,

I'm working on some columns that alternate between salary and quantity. I have thousands of columns. I need to sum each salary column and place each sum at row 51. Then I need to get the average for each salary column and place that on line 52. The number of salaries is already on row 50 for each, so the average would have to be taken by taking the sum and dividing by the number of salaries already on row 50. The difficulty with this is, first getting the sums for each salary column and placing them on the corresponding columns on row 51. Then having the average calculation be placed on row 52 for each salary column.

Can someone help?

Thanks

[harrisonland]

Hi there. Please can you post a copy of your worksheet so we can take a look. It's much easier to propose a solution in your (desensitized) copy.

See the yellow band at the top of the page for details.

Tim

[Pandrade]

Hi Harrisonland,
I attached a sample. Thanks for responding. Hope you can help.

[harrisonland]

Ok... looking at your sample, the sum of salaries (assuming the "Quantity" may not always to be 1) for column B is

Please Login or Register  to view this content.

and the column average will be:

Please Login or Register  to view this content.

Having that in mind, you could run a VBA routine like this to complete all columns in one fell swoop:

Please Login or Register  to view this content.

Is that what you had in mind?

Tim

[Pandrade]

Wow! That works great! Thank you

[harrisonland]

If you consider the issue sorted, don't forget to mark the thread [SOLVED] using the thread tools at the top of the page.

You can also show your appreciation for those who have helped by clicking the * at the left of each post to give feedback.

Tim