| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNT IF BETWEEN DATES
column A has dates, column B has a,b,c,.......
I need to count by Fiscal Year Quarters (10/01/05-12/31/05)only those that have an F in column B. I had been using this formula array, for some reason I can't change, alter, copy paste or do anything to it. The input has change but the output hasn't. If I remove the column B reference I still get the correct result of all between those dates, but as soon as I ask for only those with F..... =SUM(('REAR D'!$C$2:$C$500="10/01/05")*('REAR D'!$C$2:$C$500<="12/31/05")*('REAR D'!$B$2:$B$500="F")) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| need to convert list of dates to count no. of dates by week | Excel Worksheet Functions | |||
| Count No. of times Dates are repeated | Excel Discussion (Misc queries) | |||
| How to count dates within a certain range in a column with mutiple date range entries | Excel Worksheet Functions | |||
| count date occurances in range of dates... | Excel Worksheet Functions | |||
| How do I count cells in a column of dates between date ranges? | Excel Worksheet Functions | |||
Threaded Mode
