Hi all, this seems a really simple one but I can't crack it!
I want to look at two columns and count the number of times ONE particular word appears.
I've tried =COUNTIFS(A:A,"Word",G:G,"Word") to try and count the number of times 'Word' appears in both column range A and column range G, but it doesn't seem to work?
Thanks in anticipation...
I want to look at two columns and count the number of times ONE particular word appears.
I've tried =COUNTIFS(A:A,"Word",G:G,"Word") to try and count the number of times 'Word' appears in both column range A and column range G, but it doesn't seem to work?
Thanks in anticipation...