Sum of column in Multi Rows

[jonboy6257]

Hello, I have a workbook where I am trying to sum and average the data in each row (rowsize will vary) and place it in a specific column. For example the sum of columns in A2 will go in column AA:22 or somewhere depending on location of buttons. I am getting confused on how to cycle through each row and use VBA to find the SUM and then AVG. I tried jumping into VBA to quickly and feel I need to do some reading this weekend! Anyways, any help would be appreciated. I have included a sample workbook.

[stnkynts]

This makes absolutely no sense

the sum of columns in A2 will go in column AA:22

[jonboy6257]

Sorry I didn't read what I typed! Let me word it differently. The sum of all Columns in Row 1 will go into Cell A22.

[stnkynts]

Still confused. You said Row A but do you mean Column A? Cell A22 already has a value in it and it is a completely random spot. Did you upload the correct workbook? Try

Please Login or Register  to view this content.

[jonboy6257]

Sorry for the mix up. I was looking for the sum of all columns in Row 1. It should be AA22 not A 22.

[jonboy6257]

Thanks again, it does exactly what I need it to.

[jaslake]

Hi jonboy

You really don't require VBA to do this

Place this Formula in AA2 and drag down

Please Login or Register  to view this content.

And this Formula in AB2 and drag doun

Please Login or Register  to view this content.

[jonboy6257]

I needed VBA because the amount of Names will vary once imported. I pull a .CSV file in with VBA and than manipulate the data to remove those who didn't work. As new employees are hired the list will grow and vice versa in regards to firing people. I should have put that the amount of rows will vary. The only constant is the number of columns.