| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Average Formula to display blank cell if named range is blank | Excel Worksheet Functions | |||
| Start Cell B1 then find first blank cell, insert subtotal, next non blank, then next blank, sutotal cells in between......... | Excel Programming | |||
| Need macro to check if cell is not blank & previous cell is blank, copy information from row above & paste | Excel Programming | |||
| Copy to first Blank cell in Colum C Non blank cells still exist be | Excel Programming | |||
| COPY A CONCATENATE CELL TO BLANK CELL PUTTING IN THE NEXT BLANK C. | Excel Discussion (Misc queries) | |||
Threaded Mode
