Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Lookup, dsum??
I have two columns of data.
1st col. contains names (names can occur several times) 2nd col. contains numbers. I would like to create a list of those names and total the numbers associated with those names. Eg. ___ ____ ___ ____ Jack 10 Result Jack 15 Jill 5 Jill 5 john 3 John 3 Jack 5 Thanks for the help Ken |
#2
|
|||
|
|||
=SUMIF(A1:A7,D2,B1:B7)
enter on cell D2 a name present on the A1:A7 range "Ken" wrote: I have two columns of data. 1st col. contains names (names can occur several times) 2nd col. contains numbers. I would like to create a list of those names and total the numbers associated with those names. Eg. ___ ____ ___ ____ Jack 10 Result Jack 15 Jill 5 Jill 5 john 3 John 3 Jack 5 Thanks for the help Ken |
#3
|
|||
|
|||
You can use a Pivot Table to summarize the data. There are instructions
in Excel's Help, and Jon Peltier has information and links: http://peltiertech.com/Excel/Pivots/pivotstart.htm Ken wrote: I have two columns of data. 1st col. contains names (names can occur several times) 2nd col. contains numbers. I would like to create a list of those names and total the numbers associated with those names. Eg. ___ ____ ___ ____ Jack 10 Result Jack 15 Jill 5 Jill 5 john 3 John 3 Jack 5 Thanks for the help Ken -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup function w/Text and Year | Excel Worksheet Functions | |||
Use of the DSUM formula to find exact matches in datatables | Excel Worksheet Functions | |||
Index table lookup anomaly | Excel Worksheet Functions | |||
Excel Lookup Functions | Excel Worksheet Functions | |||
double lookup, nest, or macro? | Excel Worksheet Functions |