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

Best phone camera 2017

Stunning new film posters by Hattie Stewart, Joe Cruz & more

iPad Pro 10.5in (2017) review

28 astuces pour profiter au mieux de votre iPhone