Excel formula wanted

  lindyloo4 14:50 08 Oct 2007
Locked

Is there any way I can make a column of Y's add up as though it were a column of 1's. I need to put Y for Yes but want to know how many of them there are.

Thanks in advance

  Fermat's Theorem 15:22 08 Oct 2007

as in
=COUNTIF(A1:A5,"y")will count all the entries in A1 to A5 that contain y

Hope this helps :-)

  lindyloo4 15:34 08 Oct 2007

Perfect!!!!!!! Thank you, just what I wanted.

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