counting in excel columns

  Newuser3477 14:26 26 Mar 10
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 10

Try

=COUNTIF(A:A,"x")

  Newuser3477 16:33 26 Mar 10

Works fine thanks

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

The Legend of Zelda Breath of the Wild review: Five hours with Zelda on the Nintendo Switch

1995-2015: How technology has changed the world in 20 years

How the painting-like animated sequences in A Monster Calls were created by Glassworks Barcelona

The 22 best Safari extensions | Best Safari plugins: Improve Apple's Safari web browser with these…