software

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!

=SUMIF(A2:A16,quot;Bondingquot;,D216)

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
quot;Martinquot; wrote:

gt; Can somebody help me on this.
gt;
gt; Column A contains name of different dimensions and is repeated in some of
gt; the row.
gt; Column F contains the data for dimensions. If I import more data from text
gt; file, Column H contains same name as Column A but has another set of data at
gt; Column M. So I f do multiple import by macro, I will have data at column
gt; T,AA,AH etc.
gt; How to sum up all the data in different column based on the Column A Name by
gt; using formulas?
gt;
gt; E.g after import
gt;
gt; Column A Column F Column H Column M Column 0 Column T
gt; Bonding 0.3 Bonding 0.2 Bonding
gt; 0.2
gt; Bonding 0.3 Bonding 0.2 Bonding
gt; 0.2
gt; Height 1.0 Height 1.1 Height
gt; 1.2
gt; Height 1.0 Height 1.1 Height
gt; 1.2
gt; Thickness 2.0 Thickness 2.0 Thickness
gt; 2.0
gt; Thickness 2.0 Thickness 2.0 Thickness
gt; 2.0
gt; Bonding 0.2 Bonding 0.3 Bonding
gt; 0.2
gt; Bonding 0.2 Bonding 0.3 Bonding
gt; 0.2
gt;
gt; Bonding Total = Sum of all columns that contains data for Bonding.
gt;
gt;
gt; Thanks!

=SUMIF(A1:IQ16,quot;Bondingquot;,F1:IV16)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Martinquot; gt; wrote in message
...
gt; Can somebody help me on this.
gt;
gt; Column A contains name of different dimensions and is repeated in some of
gt; the row.
gt; Column F contains the data for dimensions. If I import more data from text
gt; file, Column H contains same name as Column A but has another set of data
at
gt; Column M. So I f do multiple import by macro, I will have data at column
gt; T,AA,AH etc.
gt; How to sum up all the data in different column based on the Column A Name
by
gt; using formulas?
gt;
gt; E.g after import
gt;
gt; Column A Column F Column H Column M Column 0 Column T
gt; Bonding 0.3 Bonding 0.2 Bonding
gt; 0.2
gt; Bonding 0.3 Bonding 0.2 Bonding
gt; 0.2
gt; Height 1.0 Height 1.1 Height
gt; 1.2
gt; Height 1.0 Height 1.1 Height
gt; 1.2
gt; Thickness 2.0 Thickness 2.0 Thickness
gt; 2.0
gt; Thickness 2.0 Thickness 2.0 Thickness
gt; 2.0
gt; Bonding 0.2 Bonding 0.3 Bonding
gt; 0.2
gt; Bonding 0.2 Bonding 0.3 Bonding
gt; 0.2
gt;
gt; Bonding Total = Sum of all columns that contains data for Bonding.
gt;
gt;
gt; Thanks!