View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] goldkarat24@gmail.com is offline
external usenet poster
 
Posts: 3
Default Sum after every blank cell

Hello,

I love this website!! I have a problem that I am going nuts over. In
column A I have several numbers from A1 to A100
In that column there may be random blank spaces like A10 is blank, A15
is blank then A40 is blank.I would like a formula in column B that
sums A1to A9 then sums A11 to A14. Inotherwords, is there a formula
that will give me a sum after there is a blank cell?
Thanks