Misread your post. Apologies. Dismiss the SUMIF. But here's how you can use
the pivot to get the desired results: Assume the top col labels for cols B &
N a Loc, Amt. In the wizard's Layout step, just drag n drop Loc & Amt into
ROW area, one below the other, then double-click on Loc to set Subtotals to
None. And drag n drop Loc in the DATA area (it'll show as Count) Click OK
Finish for the desired results. The pivot will give you both the uniques
listing of all the Site-Amt combos in the ROW area, and the corresponding
Counts. You could also explore pivot charting directly from the pivot. Just
right-click on any cell in the pivot Pivot Chart
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,000 Files:362 Subscribers:61
xdemechanik
---