2 Replies Latest reply: Oct 28, 2016 2:58 AM by Paul Roberts RSS

    Count if contains a specific letter

    Paul Roberts

      Hi all,

              I'm trying to count the amount of cells in a column that contains a J. I'v tried COUNT(IF(Job='J',Job)) but it returns with a 0, which i know isn't true.

       

              I'm quite new to this and realise this is probably a silly question with a simple answer, but i did have a google to no avail.

       

      Thanks in advance