| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Choose merged cell and sum data
I have a worksheet with the following data. I want to choose 010 then
sum 'total sent' with a formula. The problem I'm having is the 6 cells containing 010 that I'm referencing are merged. I maybe eventually accessing many simular worksheets possibling using VBA Site Number Metrics Total Sent Total Failed 010 13 1 0 112 2 0 197 3 0 199 2 0 214 1 0 218 1 0 011 13 1 0 199 1 0 012 315 1 0 015 13 1 0 021 199 1 0 Total 15 0 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can't choose an imput cell for my data table in another worksheet | Excel Discussion (Misc queries) | |||
| Autofit Merged cell Code is changing the format of my merged cells | Excel Discussion (Misc queries) | |||
| Merged cell data tabulated in columns | Excel Worksheet Functions | |||
| how do i link merged cells to a merged cell in another worksheet. | Excel Worksheet Functions | |||
| How do I choose a cell colour, without it being tied to the data? | Excel Discussion (Misc queries) | |||
Threaded Mode
