Converting Letters To Numbers Summary???

B

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
 
I

isabelle

hi Tia,

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

all my wishes of happiness!
isabelle

Le 2014-04-23 21:57, [email protected] a écrit :
 
B

bo1953

hi Tia,



you can use the formula

=COUNTIF(D1:D100,"Y")

=COUNTIF(D1:D100,"N")

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



all my wishes of happiness!

isabelle


snip snip snip snip snip
Click to expand...

Isabelle,

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

Both are appreciated.

bo1953
 
Top