| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum data different size
Hi Guys,
I have a spreedsheet that looks like this: Column A Column B ColumnC XXXX 1000 HERE I want the sum result YYY 1200 ZZZZ 1100 blank XXXX 1000 HERE I want the sum result YYY 1000 blank ZZZ 500 HERE I want the sum result I am trying to find a formula to sum column B up to the blank since column B can vary sizes I don't how to tell the formula to sum until there is a blank and place the result in the first row of the data range in column C (HERE I want the sum result). please help me XOXOXOX Pamela |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| specify data size in cell add 0's | Excel Worksheet Functions | |||
| Data Label size | Excel Worksheet Functions | |||
| Set Circle Size from cell data? | Excel Discussion (Misc queries) | |||
| Cell size? Or size limit for Text data type? | Excel Discussion (Misc queries) | |||
| Change the size of the data labels | Charts and Charting in Excel | |||
![Pamela[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
