Countifs with null or blanks

**shuddle** · 10-07-2011, 02:34 PM

I'm working in 2007.

I'm trying to write a countifs formula for it to count only the cells of FY12WOcount that have data (cell example 012511-01) and the cells of FY12 DateResolved that has a date in it.

This is what I'm using but it is not working.

=COUNTIFS(FY12WOCount,"",FY12DateResolved,"?")

**TMS** · 10-07-2011, 02:44 PM

Try:

=COUNTIFS(FY12WOcount,"<>",FY12DateResolved,"<>")

Regards

**shuddle** · 10-14-2011, 02:33 PM

I get a Value error but I think it is because one is a number field and the other a date field. I think I found another way to do it. I will close this post. Thank you for your help.