Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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! |