First:
"Question is how can I indicate either blanks or nonblanks in one of the 4
reference cells in row 205."
I presume you mean -exclude cells with blanks? In that case
=SUMPRODUCT((A1:A200=A205:D205)*(B1:B200=1)*(A205: D205<0))
Second:
I think you mean --
http://www.mcgimpsey.com/excel/formulae/doubleneg.html
Hope it helped
Ola Sandström