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....

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....

well, found it....finally
SUMPRODUCT(--(ISNUMBER(MATCH(CNSHSV,{"MI","SI","OB},0))),--(CNSDAY=E3),CNSQTY))

"Tasha" wrote:

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....