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

Galaxy Note 8 vs iPhone X

This is what design agencies will look like in 2032

How to update iOS on iPhone or iPad

WhatsApp : comment lire vos messages sans que l’expéditeur le sache