I find this easier to read:

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

But this: "5/31/06" is just a string--not a date.

Bob likes to use: --"5/31/06" that coerces that string into a number and dates
are just numbers nicely formatted to excel.

"s2m via OfficeKB.com" wrote:

I need to count in 2 columns this condition.

Column Z =< 5/31/06

Column AA = blank date fields

I've tried this but it does not work

=SUMPRODUCT(--(TCS!$Z$2:$Z$1000<="5/31/06"),--(TCS!AA2:AA1000=""))

Much thanks

Sharon

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200606/1

--

Dave Peterson