# Isblank and Sumproduct

#### Ody

##### Board Regular
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>

### Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"
Excel Workbook
ABCDEF
1nametypecreditdate
2joexx12
3joeyy11.1.20102
4joeyy1
5joeyy1
Sheet

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<>""))

Replies
3
Views
123
Replies
5
Views
232
Replies
0
Views
122
Replies
3
Views
214
Replies
0
Views
55

1,203,379
Messages
6,055,096
Members
444,761
Latest member
lneuberger

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back