=SUMIF(A2:A16,"Bonding",D2:D16)

Column A would contain your naming
convension( Thickness, Bonding etc)
And in Column D resides the numbers for this formula.... adjust the columns
and rows to your needs



"Martin" wrote:

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!