| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add and summarize function
All,
I have a worksheet called 'data' in which I have two colounms of data shown below: CODE VALUE XXX 1 XXX 22 XXX 21 XXX 45 BBB 64 NNN 54 AAA 64 Using VBA how can I add up all the XXX codes and produce an output total in a worksheet labelled 'output'? For example in this case the worksheet 'output' would display XXX 89 Thanks for your help, Regards Joe Crabtree |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| pivot tables - totals different than the summarize function | Excel Discussion (Misc queries) | |||
| pivot tables - total different than the summarize function | Excel Discussion (Misc queries) | |||
| What function do I use to summarize data levels on three sheets? | Excel Worksheet Functions | |||
| Function to summarize based on 2 conditions? | Excel Discussion (Misc queries) | |||
| Using Pivot Table Function to Summarize | Excel Discussion (Misc queries) | |||
Threaded Mode
