Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
hi again - I hope it's OK to ask 2 questions on the same day! This problem
is related to the one I posed earlier, but more general. Let's say a sheet has 3 columns. Columns A and B contain numbers, but there are also varying numbers of blank cells. I'm looking for a formula I can drag down in column C that sums the B value (if it exists) and the first A value encountered on the same row or above. Here is a sample. A B C 6 1 7 7 13 3 9 8 4 12 2 10 7 3 10 What drag-down formula can I use in Column C? I'm really knew at this, and I'm grateful for any clues. Victoria |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Index/match - make blank cells return a blank value. | Excel Worksheet Functions | |||
Excel 2002: Return blank when VLOOKUP on blank cells | Excel Discussion (Misc queries) | |||
Nested IF - return a blank when compared cells are blank | New Users to Excel | |||
Maximum Number of Blank Cells between Non Blank Cells in a Range | Excel Worksheet Functions | |||
Imported Data creates blank cells that aren't really blank | Excel Worksheet Functions |