Isblank and Sumproduct

[Ody]

hello all,

i have a quick question.

I'm trying to get isblank to work nested inside a sumproduct formula and despite my efforts I'm failing. I could have sworn I got it to work the other day but now cant replicate my results.

here is my formula:
SUMPRODUCT((A2:A4="joe")*(B2:B4="yy")*(C2:C4)*(isblank(D2:D4))

I would expect the result to be 2 instead of 3 because I don't want it to count the record with a date. What am I missing? Thanks for any help!


Here is a sample table

name	type	credit	date
joe	xx	1
joe	yy	1	1/1/2010
joe	yy	1
joe	yy	1

<tbody>
</tbody>

 

[Misca]

Excel Workbook
	A	B	C	D	E	F
1	name	type	credit	date
2	joe	xx	1			2
3	joe	yy	1	1.1.2010		2
4	joe	yy	1
5	joe	yy	1
Sheet

 

[Ody]

Thanks for the input!

I was also able to get the same result with this f(x):

SUMPRODUCT((A2:A4="joe")*(B2:B4="yy")*(C2:C4)*(isblank(D2:D4<>""))