| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
sum next two non-empty cells in a range
is there a way to tell excel to sum the next two non-empty cells in a range?
A1 = 5 A2 = "" A3 = "" A4 = 4 A5 = "" A1 = 5 A2 = 4 A3 = "" A4 = 7 A5 = "" if i wanted to evaluate A1:A5, and add only the first two non-empty cells, so either way, the formula would return the result of 9. TIA. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CountIF cells are not empty | Excel Discussion (Misc queries) | |||
| Sumproduct ... Empty Cells vs Spaces? | Excel Discussion (Misc queries) | |||
| How can I dynamically eliminate blank cells in a given range in E. | Excel Worksheet Functions | |||
| Empty Cells, Spaces, Cond Format? | Excel Discussion (Misc queries) | |||
| How do you delete one cell from a range of protected cells | Excel Worksheet Functions | |||
Threaded Mode
