Countif between a range?
 

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 between a range?
 

=SUMPRODUCT(--(MONTH(B6:B80)=10),--(MONTH(B6:B80<=12)))

for Q4, or maybe

=SUMPRODUCT(--(INT((MONTH(B6:B80)-1)/3)+1=4))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Keeprogoal" wrote in message
...
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 between a range?
 

=SUMPRODUCT(--('Tower Age'!B6:B80=DATE(2005,10,1)), --('Tower
Age'!B6:B80<=DATE(2005,12,31)))

For explanation see
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
http://mcgimpsey.com/excel/formulae/doubleneg.html

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Keeprogoal" wrote in message
...
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