| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Add cells between blank cells
I have numbers in cells I2:I20, cell I21 is blank and then more numbers in
cells I22:I30 and I31 is blank. This will repeat down the sheet. I would like a formula in column J to sum all the numbers in between the blank cells. In cell J20 I would like it to sum cells I2:I20, in cell J30 sum cells I22:I30, etc. I know I can go to those cells and enter the sum equation but is there something I can copy down the sheet? Let me know if you don't understand and I will try to rephrase the question. Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| zero value cells/blank cells causing error in AVERAGE? | Excel Worksheet Functions | |||
| Range naming cells with blank cells through coding | Excel Discussion (Misc queries) | |||
| Maximum Number of Blank Cells between Non Blank Cells in a Range | Excel Worksheet Functions | |||
| Excel inserted 0's in cells linked to blank cells | Excel Discussion (Misc queries) | |||
| How do I skip blank cells when copying over a range of cells? | Excel Discussion (Misc queries) | |||
Threaded Mode
