Ken

Posts: n/a

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Lookup function w/Text and Year	Josh O.	Excel Worksheet Functions	1	February 12th 05 11:27 PM
Use of the DSUM formula to find exact matches in datatables	Rob Henson	Excel Worksheet Functions	1	January 27th 05 02:14 AM
Index table lookup anomaly	Carole O	Excel Worksheet Functions	9	December 9th 04 04:33 PM
Excel Lookup Functions	Paul Adams	Excel Worksheet Functions	1	November 10th 04 02:40 PM
double lookup, nest, or macro?	Josef.angel	Excel Worksheet Functions	1	October 29th 04 09:50 AM

All times are GMT +1. The time now is 10:48 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us