| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif between a range?
On Wed, 21 Jun 2006 15:04:03 -0700, Keeprogoal
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Countif between a range? | Excel Discussion (Misc queries) | |||
| 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 | |||
| CountIf first column range = "Word" and second column range <> 0 | Excel Worksheet Functions | |||
| Countif for specific cells rather than a range ???? | Excel Worksheet Functions | |||
Hybrid Mode
