| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup value in one column & add the values in adjacent columns
My sheet has repeating values in column "A" i.e. 1, 2, 3,or 4.
i wish to lookup the numbers 1's and sum the adjacent cloumn. A B- 1 1 120 2 3 100 3 4 50 4 1 120 -------------- Browny |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup all values within multiple columns and copy to new column | Excel Discussion (Misc queries) | |||
| When data match, copy adjacent value to adjacent column | Excel Worksheet Functions | |||
| summing values from adjacent column with refrence from adjacent column | Excel Discussion (Misc queries) | |||
| Sum up values from adjacent column | Excel Discussion (Misc queries) | |||
| To copy values in a column relevant to text in an adjacent column? | Excel Worksheet Functions | |||
Threaded Mode
