Excell Formula
 

I am trying to set up a spreadsheet that tallies for every "Y" is a "1" and
every "N" is a "0".

Excell Formula
 

Take a look at the CountIf function.
Ex: =COUNTIF(A:A,"Y")
HTH,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"Riece" wrote:

I am trying to set up a spreadsheet that tallies for every "Y" is a "1" and
every "N" is a "0".