Pivot Table Sub Total Count Unique Dates

M

MFM

When I roll up a data set which includes dates the count sub total add every
occurance of the date. I would like to count how many days.
 
S

Shane Devenshire

Hi,

Your title doesn't agree with your question? Are you trying to count the
number of different dates, but in the question you ask to count how many
days? not dates?

In the pivot table there is no Count Distinct function, but you could put a
formula in the spreadsheet the counts all the dates in the Date field, for
example

=COUNT(B10:B100)

Cheers,
Shane
 
M

MFM

Thanks for your comments.

I was looking for "dates" which as you stated there is no distincet within
pivot tables.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Average of Subtotals in Pivot Table 0
count dates 4
count the dates for each criteria and list total occurances for ea 1
Excel Formula - Count Dates from another Sheet 8
combine column labels in pivot table 3
Determine Most/Least Frequent Date from List 2
Formula to count the number of unique dates 7
Counting dates including the beginning date. 2

Top