Advertisement
Guest User

Untitled

a guest
Jun 26th, 2019
69
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.17 KB | None | 0 0
  1. =IF(ISNUMBER(SEARCH("LOS",$A6))=TRUE,$C6,"")
  2.  
  3. =IF(SUMPRODUCT(COUNTIF($A6,{"*LOS*","*DTS*"})),$C6,"")
  4.  
  5. =SUMPRODUCT(SUMIF(C:C,A:A,{"*LOS*","*DTS*"}))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement