Converting Letters To Numbers Summary???

[bo1953]

Hello all, I have created a spread sheet in excel for my wedding with a list of all invited guests with several columns. I want to be able to summarize the "Response" column with either Y or N and have them summarized at the bottom of it with a the total of each in two columns.

Is this a can do or must I use two columns for this type of data?

TIA - bo1953

 

[isabelle]

hi Tia,

you can use the formula
=COUNTIF(D1100,"Y")
=COUNTIF(D1100,"N")
adjust "D" and "100" for your column and line number

all my wishes of happiness!
isabelle

Le 2014-04-23 21:57, (e-mail address removed) a écrit :

 

[bo1953]

hi Tia,



you can use the formula

=COUNTIF(D1100,"Y")

=COUNTIF(D1100,"N")

adjust "D" and "100" for your column and line number



all my wishes of happiness!

isabelle


snip snip snip snip snip

Isabelle,

Thank you so very much for the solution. As well for you well wishes...

Both are appreciated.

bo1953