Trouble with Countif

SmokeEater · Nov 8, 2005

I am trying to get a count of column F where it has a date of 31-Dec-2005 and where column E is blank. I thought this formula would do the trick

Code:

=COUNTIF(Tasks!F:F,AND(Tasks!E2:E147=DATEVALUE("31-dec-2005"),ISBLANK(Tasks!F2:F147)))

The only result I get is 0, there are 39 occurances, I counted them the old fashioned way, one at a time.

GlennUK · Nov 8, 2005

Code:

=SUMPRODUCT((Tasks!E2:E147=DATEVALUE("31-dec-2005"))*(ISBLANK(Tasks!F2:F147)))

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

SmokeEater · Nov 8, 2005

Thanks Glenn. Now I can see if I can stick my hair back in. I was pulling on it too much trying to figure this out.

arthurbr · Nov 8, 2005

Hi smoke,
Glenn is a star, so why don't you give him one ?
Cheers
André