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! |
#2
|
|||
|
|||
Sum values Col.A w/ indntcal values in Col.B, w/o naming Col.B val
Hi!
If you can create a column that lists the unique values from column A (you can do this easily using an Advanced filter) to, say, column D, starting in D1: D1 = 1111 D2 = 2222 D3 = 3333 Then enter this formula in E1 and copy down as needed: =SUMIF(A$1:A$10,D1,B$1:B$10) Biff "STILLA" wrote in message ... 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! |
#3
|
|||
|
|||
Sum values Col.A w/ indntcal values in Col.B, w/o naming Col.B val
Hi
A classical Pivot-Table task. -- Arvi Laanemets ( My real mail address: arvil<attarkon.ee ) "STILLA" wrote in message ... 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! |
#4
|
|||
|
|||
Sum values Col.A w/ indntcal values in Col.B, w/o naming Col.B
Biff! Many, many thanks! I'm going to try this. Although I've since found I
can get results via pivot tables, I may prefer to have the results straight on my worksheet. Thanks again for the speedly reply! Stilla "Biff" wrote: Hi! If you can create a column that lists the unique values from column A (you can do this easily using an Advanced filter) to, say, column D, starting in D1: D1 = 1111 D2 = 2222 D3 = 3333 Then enter this formula in E1 and copy down as needed: =SUMIF(A$1:A$10,D1,B$1:B$10) Biff "STILLA" wrote in message ... 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! |
#5
|
|||
|
|||
Sum values Col.A w/ indntcal values in Col.B, w/o naming Col.B
Arvi,
Pivots - OF COURSE! DUH is me! Many thanks for the speedly reply! Stilla "Arvi Laanemets" wrote: Hi A classical Pivot-Table task. -- Arvi Laanemets ( My real mail address: arvil<attarkon.ee ) "STILLA" wrote in message ... 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|