Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I see nothing wrong with your expression. That implies that there are no records where Job = 'J'. Perhaps there are spaces after the J?
You might try: if(trim(Job)='J'
or: if(index(Job,'J')>0
I see nothing wrong with your expression. That implies that there are no records where Job = 'J'. Perhaps there are spaces after the J?
You might try: if(trim(Job)='J'
or: if(index(Job,'J')>0
Brilliant, thank you! The second one worked a treat!