Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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.... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
sumproduct? sumif(sumproduct)? | Excel Worksheet Functions | |||
SUMPRODUCT(--ISNUMBER(FIND("AM",C5:160))*(k5:k160="") | Excel Discussion (Misc queries) | |||
Sumif...SumProduct...Sum Something | Excel Discussion (Misc queries) | |||
Sumif or Sumproduct | Excel Worksheet Functions | |||
isnumber with sumproduct | Excel Worksheet Functions |