K
Kay
Hello all,
I have looked through the archives and have seen several formulas that
should work in my spreadsheet, but return either a 0 or the wrong number.
The dates are entered using 1/6/08 and formatted to appear as Jan-08. I want
to count the number of cells that have Jan as a date, etc.
I have tried the following:
=COUNTIF(Data!F2:F65536,">=1/1/2008") -COUNTIF(Data!F2:F65536,"<=1/31/2008")
The result counts all cells rather than the 50 it should be
=SUM(COUNTIF(F2:F65536,{">12/31/08","<=1/1/09"})) the result is 0
=SUMPRODUCT((MONTH(Data!F2:F65536)=1),(YEAR(Data!F2:F65536)=2008)) the
result is 0
I am stumped.
Would really appreciate the help!
I have looked through the archives and have seen several formulas that
should work in my spreadsheet, but return either a 0 or the wrong number.
The dates are entered using 1/6/08 and formatted to appear as Jan-08. I want
to count the number of cells that have Jan as a date, etc.
I have tried the following:
=COUNTIF(Data!F2:F65536,">=1/1/2008") -COUNTIF(Data!F2:F65536,"<=1/31/2008")
The result counts all cells rather than the 50 it should be
=SUM(COUNTIF(F2:F65536,{">12/31/08","<=1/1/09"})) the result is 0
=SUMPRODUCT((MONTH(Data!F2:F65536)=1),(YEAR(Data!F2:F65536)=2008)) the
result is 0
I am stumped.
Would really appreciate the help!