Really "1"?

=SUMPRODUCT(--($B$2:$B$20="1"),--(ISNUMBER(MATCH($D$2:$D$20,{640,641},0))),$I$2:$I$ 20)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"mike_vr" wrote in message
...
Hi all,

Wonder if anyone can help me. Using Excel 2007 and the SumIfs function. I
have my sum range, and my first criteria range

=SUMIFS($I$2:$I$2000,$B$2:$B$2000,"1",

i.e. sum anything in column I that equals to a one from column B.

But for my second criteria range $D$2:$D$2000,the value can be one of 14
possibilities 6400, 6401, 6402 up to 6412 as well as anything beginning
with
KA.

So basically I'm trying to find out if there's a way to sum something if
it
equals a 1 in the one column, and then a range of possibilities in another
column after that.

Is this possible? Any help would be appreciated!

Thanks,

Mike