Excel PivotTable Count instead of Sum

[BlindPete]

Hello,

I written a VBA routine to create a pivot table from data on another sheet. The routine works fine except that the "data" cells are count() instead of sum(). I've been searching for a long while and can find an any examples of someone changing what the data portion of the pivot table summarizes by.

Any ideas where to look? or a snippet would be even better!

-Pete
Games the old fashion way with Dice, Paper and Pencils!

 

[PHV]

Did you try to macro record the manual process of creating the right pivot table ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[BlindPete]

I am embarrassed by how easy that was to figure out the proper fields and methods. Thank you!

oExcelPivotTable.PivotFields("Count of Cost").Function = xlSum

-Pete
Games the old fashion way with Dice, Paper and Pencils!