count & if statements?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to figure out how to count the number of days in my spreadsheet. I have dates listed. each date may be listed more than once but I only want to count it on the first occurence. How would I do this?
 
Ctrl/Shift/enter this formula, where the range used is all your dates
=SUM(1/COUNTIF(C1:C40,C1:C40)
It will give # of unique value

----- Debbie Smith wrote: ----

I am trying to figure out how to count the number of days in my spreadsheet. I have dates listed. each date may be listed more than once but I only want to count it on the first occurence. How would I do this?
 
Back
Top