Thread: sumproduct
View Single Post
  #3   Report Post  
Ola
 
Posts: n/a
Default

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