Range B4:E100, want to sum all results of the followng
* Looking for the string "in" each row of the range, for example "inside". If "in" occurs more than one time in the same row, count only as one.
* Also, column A in the same row as the string "in" needs to be equal "CIA".
So, if column A row 5 =CIA, and row 5 contains the string "in", count as one. Sum all the number of rows that matches these two criterias.
Bookmarks