Assume the 2 col headers a "Name" & "XXX"
Build a pivot table, with "Name" placed in ROW area, & "XXX" placed twice in
DATA area (one as COUNT, the other as SUM). Then go to the pivot, drag DATA &
drop it over "Total", and you'd get the desired results, viz.: a uniques
listing of the names in col A, with corresponding counts & sums (from col
"XXX") in adjacent cols B and C
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"DP" wrote:
I have a list of names (most repeated several times) in column A that act as
a diary of work completed. I need excel to look at the names in column A and
then count / sum information found in another column. I have tried Vlookups,
if and countifs but to no avail. Any help would be appreciated.

DP