software

Hello - I knew I forgot something in my previous question!

As I said in an earlier post In column J, I have a series of cells I
want to sum at the first blank. ie

4
5
8
(blank)
8
0
2
5
(blank)

I want those blanks to sum the previous few cells, and to be bold. Then
- How can I get a total at the end of the column of ONLY those cells
with a sum in them?

Sorry about two posts - trying to do too many things at once

Thanks!Assume your values start in J2, in K2 put

One way

=IF(J2=quot;quot;,SUM($J$2:J2)-SUM($K$1:K1),quot;quot;)copy down

then format as bold or select the second column and use formatgt;conditional
formatting cell value not equal to =quot;quot; then format bold font--

Regards,

Peo Sjoblom

nwexcelsolutions.com
quot;Bleu_808quot; gt; wrote in message oups.com...
gt; Hello - I knew I forgot something in my previous question!
gt;
gt; As I said in an earlier post In column J, I have a series of cells I
gt; want to sum at the first blank. ie
gt;
gt; 4
gt; 5
gt; 8
gt; (blank)
gt; 8
gt; 0
gt; 2
gt; 5
gt; (blank)
gt;
gt; I want those blanks to sum the previous few cells, and to be bold. Then
gt; - How can I get a total at the end of the column of ONLY those cells
gt; with a sum in them?
gt;
gt; Sorry about two posts - trying to do too many things at once
gt;
gt; Thanks!
gt;
This worked for me! Thanks so much!