So the way the date is enterd matters?
Wow

So much to learn and so little time, lol

Did you see my other post about the filter count only working if i turn off
Auto Calc?

Thanks

Sharon



Bob Phillips wrote:
Try this

SUMPRODUCT(--(TCS!$Z$2:$Z$1000<=--"2006-05-31"),--(TCS!AA2:AA1000=""))

I need to count in 2 columns this condition.

[quoted text clipped - 9 lines]

Sharon

--
Message posted via http://www.officekb.com