View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Tasha Tasha is offline
external usenet poster
 
Posts: 157
Default SUMPRODUCT, SUMIF, ISNUMBER?? please help

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