View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Martin
 
Posts: n/a
Default Help me on SUMIF Problem!!!

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!