| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum value in all columns that their title is the same
I have a given data set:
S1 S1 S2 S2 S2 S3 Type A 1 3 6 7 2 2 Type B 4 4 5 3 1 2 Type C 5 4 3 2 2 3 And below is my table: Item Type Step TOTAL Item 1 Type A S1 Item 2 Type B S2 Item 3 Type C S3 I want to sum the total of all the same step in above table based on the condition of Type and Step in below table. How to do that? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I title columns with out them having a row number? | Excel Discussion (Misc queries) | |||
| How do I title columns in excel? | Setting up and Configuration of Excel | |||
| Selecting Columns by Title | Excel Programming | |||
| columns title | Excel Discussion (Misc queries) | |||
| how do i title columns | New Users to Excel | |||
Threaded Mode
