Re: Counting Occurences Between Dates
- From: Ron Rosenfeld <ronrosenfeld@xxxxxxxxxx>
- Date: Mon, 22 Oct 2007 14:19:43 -0400
On Mon, 22 Oct 2007 10:35:04 -0700, Blddrgn700
<Blddrgn700@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
Hi All:
I have data that contains a variety of dates that I have sorted by date. I
am trying to count the nuber of occurences in a given month. EI:
Customer x 1/1/07
Customer x 1/1/07
Customer x 1/4/07
Customer x 1/5/07
Curtomer x 1/31/07
Total occurences for this customer would equal 5.
I have been trying Countif function but it is not returning any value other
than 0 or 1, so I believe that I am missing a step. I have looked through
some of the previous posts but did not see anything that may pertain to what
I am looking for. Thank you in advance for any advice you may offer.
Blddrgn
=countif(a:a,">="&date(2007,1,1) - countif(a:a,">"&date(2007,1,28)
--ron
.
- Prev by Date: Re: referring to previous work*** in workbook
- Next by Date: Time Number Format
- Previous by thread: Re: Counting Occurences Between Dates
- Next by thread: Re: Counting Occurences Between Dates
- Index(es):
