sumproduct

  • Thread starter Thread starter Lowan Chan
  • Start date Start date
L

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!
 
That will exclude all rows in J2:J20000 that contain *only* the single
letter h.

Is that what you intended?
 
Back
Top