Hello - I discovered this group today and have already found some very
useful info! I do have a problem I hope can one can help me with! :)

Column J is a series of values, I would like to sum at each blank cell
immediately following the series. I would also like the sum to be in
bold.

examplea

8
1
2
(blank)
3
4
6
(blank)

I found a few examples, but the macros did not work for me. I am
*very* new to macros, the simpler the better please.

Thanks in advance!

Bleu

HI Bleu_808,

Without using macros...

Select all of column J by clicking on the 'J' header.
Use the menu item Edit -- GoTo...
Click Special...
Check the Blanks radio button, and click OK
Click the AutoSum toolbar button (sigma)

Ed Ferrero
Microsoft Excel MVP
http://www.edferrero.com

Hello - I discovered this group today and have already found some very
useful info! I do have a problem I hope can one can help me with! :)

Column J is a series of values, I would like to sum at each blank cell
immediately following the series. I would also like the sum to be in
bold.

examplea

8
1
2
(blank)
3
4
6
(blank)

I found a few examples, but the macros did not work for me. I am
*very* new to macros, the simpler the better please.

Thanks in advance!

Bleu

Ed,

Thanks. I had to enter a formula after hitting auto sum, and I was
lost. Thanks for your help though!