Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi All,
I have three rows of data I was hoping to consolidate into one row. My data set looks something like this... colA colB colC colD colD Joe 4 14 12 2 Joe 2 0 0 1 Joe 4 5 2 5 Bob 4 3 2 4 Bob 5 6 34 5 Tim 12 43 45 5 What I would like to do is create one row summing the values int he column for each individual so that it looks something like this.... colA colB colC colD colD Joe 10 19 14 8 Bob 9 9 36 9 Tim 12 43 45 5 Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Rows & Columns in Excel | Excel Worksheet Functions | |||
Automatically inserting rows | Excel Worksheet Functions | |||
Hiding Rows if the linked rows are blank | Excel Discussion (Misc queries) | |||
Insert rows | Excel Worksheet Functions | |||
flexible paste rows function that inserts the right number of rows | Excel Discussion (Misc queries) |