Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using COUNTIF or SUMPRODUCT for Year
I have a column of dates in numeric format of dd/mm/year, and have tried two
different formulas to count the number that fall in a specific year. When I use the formula =SUMPRODUCT(--(YEAR(C4:C24)=2001)) it returns the #VALUE! error I've tried variations of the COUNTIF formula, to no avail either. Any suggestions? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Countif month & year | Excel Worksheet Functions | |||
sumproduct for month and year | Excel Discussion (Misc queries) | |||
sumproduct in a given year | Excel Worksheet Functions | |||
Countif by Year | Excel Discussion (Misc queries) | |||
countif number of occurences per month per year. | Excel Worksheet Functions |