| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.programming
|
|||
|
|||
SUMIFs for particular cells in blocks of data
I would turn your unique identifiers into Named Ranges specifying your
blocks of data. Then it should be easy to do what you want, although you may need to use INDIRECT to create the references. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stop selecting blocks of cells | New Users to Excel | |||
| Count Blocks of Data | Excel Worksheet Functions | |||
| blocks of data repeating | New Users to Excel | |||
| Copying blocks of cells but the sizes don't copy | Excel Discussion (Misc queries) | |||
| how to split address blocks across multiple cells | Excel Worksheet Functions | |||
Threaded Mode
