Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Can somebody help me on this.
Column A contains name of different dimensions and is repeated in some of the row. Column F contains the data for dimensions. If I import more data from text file, Column H contains same name as Column A but has another set of data at Column M. So I f do multiple import by macro, I will have data at column T,AA,AH etc. How to sum up all the data in different column based on the Column A Name by using formulas? E.g after import Column A Column F Column H Column M Column 0 Column T Bonding 0.3 Bonding 0.2 Bonding 0.2 Bonding 0.3 Bonding 0.2 Bonding 0.2 Height 1.0 Height 1.1 Height 1.2 Height 1.0 Height 1.1 Height 1.2 Thickness 2.0 Thickness 2.0 Thickness 2.0 Thickness 2.0 Thickness 2.0 Thickness 2.0 Bonding 0.2 Bonding 0.3 Bonding 0.2 Bonding 0.2 Bonding 0.3 Bonding 0.2 Bonding Total = Sum of all columns that contains data for Bonding. Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
importing csv files, problem with date formats | Excel Worksheet Functions | |||
sumif problem | Excel Discussion (Misc queries) | |||
Problem with SUMIF criteria | Excel Discussion (Misc queries) | |||
Excel Display Problem | Excel Discussion (Misc queries) | |||
SUMIF problem | Excel Worksheet Functions |