VBA rookie - want to perform a sum function in a loop

**ScottBeatty** · 08-01-2014, 01:25 PM

Assuming I have values in A1:C10 and then again in A12:C22, I want a total at the end of each subset with the click of a button (I realize that the sum function is much more practical, but this what I have been requested to do). This is what I had so far but I know that the formula I have isn't working.

Formula:

Please Login or Register  to view this content.

Any help would be great!

**Olly** · 08-01-2014, 01:37 PM

Try:

Please Login or Register  to view this content.

**Olly** · 08-01-2014, 01:39 PM

Or without a loop:

Please Login or Register  to view this content.

**ScottBeatty** · 08-01-2014, 02:17 PM

Thanks, Olly. Just a heads up, the loop worked while the second one did not. The second actually turned all of my values that I wanted into zeros. Not sure why, but the loop worked perfectly. Thanks a lot.