LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
importing csv files, problem with date formats jiwolf Excel Worksheet Functions 5 March 7th 06 12:48 AM
sumif problem puiuluipui Excel Discussion (Misc queries) 6 February 5th 06 10:01 AM
Problem with SUMIF criteria Kimhull Excel Discussion (Misc queries) 5 February 1st 06 06:37 PM
Excel Display Problem Bill Martin -- (Remove NOSPAM from address) Excel Discussion (Misc queries) 0 April 19th 05 05:25 PM
SUMIF problem Hodge Excel Worksheet Functions 1 November 11th 04 11:02 AM


All times are GMT +1. The time now is 12:37 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"