Loop to SUM cells by specific range in row

[NSTurk725]

Hi, I need some help writing some code to calculate a sum. Here's what I am looking to do:

In column AD (starting at AD2), I want the value to be the sum of F2 through Q2. I would like this same calculation applied down the entire AD column. So, the value of cell AD3 would be the sum of F3 through Q3, etc.

Here is the "base" code I am trying to tweak, but have had no success. If anyone can lend me a hand, I would greatly appreciate it. Thank you in advance. Happy Holidays

Please Login or Register  to view this content.

[davegugg]

I prefer an iterative method:

Please Login or Register  to view this content.

[NSTurk725]

Hey Dave,

Thank you for responding so quickly. However, when I put the code in and ran the macro the entire AD column is still blank. Was there something I missed?

[davesexcel]

Give this a go.

Please Login or Register  to view this content.

[davegugg]

Sorry, that was dumb of me. Here is a correction. I was telling it to look at the bottom of an empty column, which is obviously going to be the first row...
Assuming column "F" will have a value in each row:

Please Login or Register  to view this content.

Also, I see davesexcel posted another way. There are usually multiple ways to accomplish tasks, and in this case his solution is much more computationally efficient.

[davesexcel]

It sucks when the OP does not even bother to respond.

[NSTurk725]

Thanks guys for the solution! Both of the suggestions you guys listed worked perfectly! I appreciate the help greatly, Sorry for the delay in response. When I originally clicked "Submit reply" the other week, it was taking forever to load the next page so I closed the window. I assumed it went through, but ti was just taking a long time to load the next page. Sorry about that. Again, I appreciate all the help. Thanks!