LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
STILLA
 
Posts: n/a
Default Sum values Col.A w/ indntcal values in Col.B, w/o naming Col.B val

Situation: A worksheet whe
-there are many duplicate ID numbers in Column A
-there are unique values in Column B

What I'd like to do:
Obtain a sum of Column B values for each distinct ID number, so that I'd get
the following results: 1111=$5.6, 2222=$4.5, 3333-$4.3, from the data below:
Col A Col B
1111 $5.0
1111 $0.6
2222 $3.5
2222 $1.0
3333 $4.3

Any assistance will be greatly appreciated. I've been searching the help
files, but I don't think I'm using the right lingo!



 
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



All times are GMT +1. The time now is 07:57 PM.

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

About Us

"It's about Microsoft Excel"