Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Greetings Excel Gurus,
I've searched the knowlege base for a formula to solve my issue, but have found nothing. Here's an illustration (where "A" is the column and numbers 1-6 downward are rows): A 1 <header 2 5 3 0 4 15 5 20 6 <formula The formula in A6 would sum cells A4 and A5 (all values 0 between the formula and first cell upward that contains a zero (wouldn't include cell A2). Thanks for your help! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Wrap Text Across Columns & Rows | Excel Discussion (Misc queries) | |||
Duplicate Range Names by worksheet | Excel Discussion (Misc queries) | |||
Help with using range names in sum function | Excel Worksheet Functions | |||
Array to named range conversion... | Excel Discussion (Misc queries) |