| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
summing adjacent data in a worksheet
I have a column of data and I need to sum the values in adjacent cells when
they are bounded before and after by cells that contain a value of 0. Then I need to sum the next group of cells bounded by zeros. So I want a column with subtotals rather than one total. The number of cells in one group may vary. I've tried using the sumif function, but what I want doesn't seem to quite fit. I'm using Excel 2007. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Summing +30 Non-adjacent cells | Excel Worksheet Functions | |||
| conditional summing of data from another worksheet | Excel Worksheet Functions | |||
| When data match, copy adjacent value to adjacent column | Excel Worksheet Functions | |||
| summing values from adjacent column with refrence from adjacent column | Excel Discussion (Misc queries) | |||
| Lookup value throughout an array_return adjacent value and summing | Excel Worksheet Functions | |||
Threaded Mode
