2 Field Comparison & Sum

K

Ken

I have data consisting of First & Last Name in seperate
Columns (A&B) ... I have number values in Col C ... I
have unique records of First & Last names from Cols A&B
in Cols (E&F) ... In Col H I need a formula that will
look at the unique records in E&F ... find the Names in
A&B & Sum the associated values found in Col C. I can
not combine 1st/last name & use SUMIF in its std
convention as this is only a sample of what I need to do.

Thanks to the many Wizards that support this board ... K

Cols A&B = Data
Col C = Counts
Cols E&F = unique records from Col A&B
Col H = Sum of Col C by unique record

ColA ColB ColC ColD ColE Col F Col G Col H
Ken A 2 Fred C 7
Fred C 3 Fred D 9
Ken D 7 Ken A 4
John B 12 Ken D 19
Fred D 9 John B 22
Ken D 10
John B 7
Ken A 2
Fred C 3
Ken D 2
Fred C 1
John B 3
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top