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
 
Ad

Advertisements

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, (e-mail address removed) a écrit :
 
Ad

Advertisements

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
Isabelle,

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

Both are appreciated.

bo1953
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top