Sum groups of numbers in first blank cell

B

Bleu_808

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
 
E

Ed Ferrero

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
 
B

Bleu_808

Ed,

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum in first blank cell and a few more things... 3
Add cells between blank cells 3
IF SUM Formula 2
Sum If Non Blank 6
Total only those cells with Sum totals 2
SUM of column based on format criteria 1
cell returning totals of 2 cols+ sending this value to another col 5
insert row when sum of values equals 100 3

Top