Formula to Add 1 to current cell if certain text is picked detected in a range of cells ... One of the columns lists the source for the property such as Zoopla, Rightmove, Fish4. I need a formula that will scan the entire Sources Column for 1 word and add a value to a cell that shows the total number of Sourced information from that source. I ...