Pivot Tables

Hi Yda, thanks for your query. When it comes to Pivot Tables SUM is the default for values; COUNT is the default for columns that contain text entries, dates, or times. If a column contains even one text entry other than the column heading, you can only COUNT the entries. Try double-checking the cell formats of the data you are pivoting, I'm willing to bet there are some text formatted entries in there. It's actually impossible (without code) to change the default analysis of a Pivot Table (see link below) which is why I reckon you've got text or date/time entries in your source data.

http://tinyurl.com/pivottabledefaultanalysis

Let me know how you get on,

Anthony