Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- =IF(ISNUMBER(SEARCH("LOS",$A6))=TRUE,$C6,"")
- =IF(SUMPRODUCT(COUNTIF($A6,{"*LOS*","*DTS*"})),$C6,"")
- =SUMPRODUCT(SUMIF(C:C,A:A,{"*LOS*","*DTS*"}))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement