| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using countif with a name of a range | Excel Worksheet Functions | |||
| checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
| Help with using range names in sum function | Excel Worksheet Functions | |||
| CountIf first column range = "Word" and second column range <> 0 | Excel Worksheet Functions | |||
| Countif for specific cells rather than a range ???? | Excel Worksheet Functions | |||
Threaded Mode
