sumproduct

[Lowan Chan]

Hi, I have a format as below, but it seems that <>"h" is not a correct
expression when I want to choose all rows except those including "h" in
column J

SUMPRODUCT((DB!$AB$2:$AB$20000=D$1)*(DB!$J$2:$J$20000<>"h")*(DB!$M$2:$M$2000="p")*(DB!$V$2:$V$20000))

Thanks a lot!

 

[T. Valko]

That will exclude all rows in J2:J20000 that contain *only* the single
letter h.

Is that what you intended?