G
Guest
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
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