I think you left out the condition to *exclude* any records where column AB
= #N/A.

--
Biff
Microsoft Excel MVP


"Max" wrote in message
...
One way which gets it all done ..

Assume source data in Sheet1, within rows 2 to 100
In Summary Sheet,
In A2:
=IF(Sheet1!C2="","",IF(COUNTIF(Sheet1!C$2:C2,Sheet 1!C2)1,"",ROW()))
Leave A1 empty

In B2:
=IF(ROWS($1:1)COUNT(A:A),"",INDEX(Sheet1!C:C,SMAL L(A:A,ROWS($1:1))))

In C2, array-entered:
=IF(B2="","",SUM(IF((Sheet1!C$2:C$100=B2)*(ISNUMBE R(Sheet1!V$2:V$100)),Sheet1!V$2:V$100)))

Select A2:C2, copy down to C100. You'd get the list of unique cust in col
B,
all neatly packed at the top, with their corresponding totals in col C
(which
will disregard #N/As if any)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik
---
"ryguy7272" wrote:
Yes! Extract and sum, so if Lucy is in C2, C3, and C4, and V2 is 7000
and V3
is 3000 and V4 is #N/A, I would like to get Lucy in A2 (on 'Summary
Sheet')
and 10,000 in B2 (on 'Summary Sheet'). Does it make sense? Then, the
other
clients running down in ColumnA (on 'Summary Sheet') and their
respective
sums in ColumnB (on 'Summary Sheet') .