Good afternoon --

I have a sumproduct formula with four conditions. One of them needs to test
a range of cells for either a "N" or a blank. I can write it to test for one
or the other, but not either one. Here's my formula:

=SUMPRODUCT(--($A$2:$A$2000=$H28),--($F$2:$F$2000=I$3),$E$2:$E$2000,--($D$2:$D$2000=""))

It's the 'D' column -- I need it to test for either a blank cell or an 'N'.

Any help would be appreciated.

TIA

Try this:

=SUMPRODUCT(--($A$2:$A$2000=$H28),($D$2:$D$2000="N")+($D$2:$D$20 00=""),--($F$2:$F$2000=I$3),$E$2:$E$2000)

--
Biff
Microsoft Excel MVP


"pdberger" wrote in message
...
Good afternoon --

I have a sumproduct formula with four conditions. One of them needs to
test
a range of cells for either a "N" or a blank. I can write it to test for
one
or the other, but not either one. Here's my formula:

=SUMPRODUCT(--($A$2:$A$2000=$H28),--($F$2:$F$2000=I$3),$E$2:$E$2000,--($D$2:$D$2000=""))

It's the 'D' column -- I need it to test for either a blank cell or an
'N'.

Any help would be appreciated.

TIA

=SUMPRODUCT(--($A$2:$A$2000=$H28),--(SIGN(($D$2:$D$2000="")+($D$2:$D$2000="N"))),--($F$2:$F$2000=I$3),$E$2:$E$2000)

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"pdberger" wrote in message
...
Good afternoon --

I have a sumproduct formula with four conditions. One of them needs to
test
a range of cells for either a "N" or a blank. I can write it to test for
one
or the other, but not either one. Here's my formula:

=SUMPRODUCT(--($A$2:$A$2000=$H28),--($F$2:$F$2000=I$3),$E$2:$E$2000,--($D$2:$D$2000=""))

It's the 'D' column -- I need it to test for either a blank cell or an
'N'.

Any help would be appreciated.

TIA