Countif between a range?

[Keeprogoal]

I am trying to set up a formula to count the number of data occurances each
quarter. I currently am using the function :

=COUNTIF('Tower Age'!B6:B80,"12/31/2005")

but that only gives me the occurances of that date.

How can I use the countif function (or any other function) to evaluate a
range of data from the 4Q: 10/01/2005-12/31/2005 and receive a count of all
the data in that falls in that range?

Thank you.
Philip

[Ron Rosenfeld]

On Wed, 21 Jun 2006 15:04:03 -0700, Keeprogoal
<[email protected]> wrote:

>I am trying to set up a formula to count the number of data occurances each
>quarter. I currently am using the function :
>
>=COUNTIF('Tower Age'!B6:B80,"12/31/2005")
>
>but that only gives me the occurances of that date.
>
>How can I use the countif function (or any other function) to evaluate a
>range of data from the 4Q: 10/01/2005-12/31/2005 and receive a count of all
>the data in that falls in that range?
>
>Thank you.
>Philip

=COUNTIF('Tower Age'!B6:B80,">=" & DATE(2005,10,1)) -
COUNTIF('Tower Age'!B6:B80,">" & DATE(2005,12,31))




--ron