Converting Letters To Numbers Summary???

  • Thread starter Thread starter bo1953
  • Start date Start date
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
 
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, (e-mail address removed) a écrit :
 
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
 
Back
Top