sumproduct
 

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$20 000<"h")*(DB!$M$2:$M$2000="p")*(DB!$V$2:$V$20000) )

Thanks a lot!

--
Lowan

sumproduct
 

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

Is that what you intended?

--
Biff
Microsoft Excel MVP


"Lowan Chan" wrote in message
...
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$20 000<"h")*(DB!$M$2:$M$2000="p")*(DB!$V$2:$V$20000) )

Thanks a lot!

--
Lowan