Hi Tasha

=SUMPRODUCT(--($E$2:$E$100=E3),
--($H$2:$H$100={"MI","SI,"OB"}),--($I$2:$I$100))

--
Regards
Roger Govier

"Tasha" wrote in message
...
This is my data:
A B C D E F G H I
102 2146 name1 11 1 9 F MI 1
103 2645 name2 11 1 3 G IC 1
104 2654 name3 2 2 4 A MI 1
107 2689 name4 3 2 1 M SI -1
161 2690 name5 8 3 1 M OB 1

I need a formula that will SUM column I if it equals MI, SI or OB and
column
E equals a cell(E3) on my sheet. I have tried several things, but keep
getting either 0's or an error. Hoping someone can help, I have spent
hours
on this and nothing so far....