counting in excel columns

  Newuser3477 14:26 26 Mar 2010
Locked

I have a spreadsheet which contains noughts,ones x, H,and A,s. I would like to count the number of x,s in each column but can't make the COUNTD function work can anybody help?
Peter

  VoG II 14:31 26 Mar 2010

Try

=COUNTIF(A:A,"x")

  Newuser3477 16:33 26 Mar 2010

Works fine thanks

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Dell XPS 13 9370 (2018) review

The art of 'British' pulp fiction

Best password managers for Mac

TV & streaming : comment regarder le Tournoi des Six Nations 2018 ?