| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count if 0 and between dates
I have been looking all over this site trying to find the answer and came up
with nothing. I have a spread sheet that contains three columns: Date Cost Award I am trying to count the number of awarded between a date(January) I have tried the sumproduct and sumif equations to come up with the following =COUNTIFS(P6:R93,"0",E6:E93,"2008Jan") - #Value! =COUNTIF(E5:E80,"=10/9/2008")-COUNTIF(E5:E80,"=10/10/2008") - This resulted in only counting the dates and not the # of Awarded HELP!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count on dates | Excel Worksheet Functions | |||
| Count if Dates are! | Excel Discussion (Misc queries) | |||
| I want to count the total Number of dates between two dates How? | Excel Worksheet Functions | |||
| Count Dates? | Excel Worksheet Functions | |||
| need to convert list of dates to count no. of dates by week | Excel Worksheet Functions | |||
Threaded Mode
