Do you mean

=IF(OR(C2="A",C2="B",C2="C",C2="D"),SUMIF(B1:B200, "<sent",A1:A200),"")

--
---
HTH

Bob


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



"Ann" wrote in message
...
had a follow up.

if column C is one of 4 statements. how do i use both?
for example, if column c is "A" then SUMIF(B1:B200,"<sent",A1:A200)