turn the letters N and Y into numbers just for totals

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i am trying to make a rollup sheet that users input Y or N depending on the
question for each column and i want a total "completed (Y)" to be displayed
below
 
Look at the COUNTIF() function

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|i am trying to make a rollup sheet that users input Y or N depending on the
| question for each column and i want a total "completed (Y)" to be displayed
| below
 
thanx it worked great. now is there a way to link them to other worksheets???
 
You must log in or register to reply here.

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

Scrabble Value calculation for Welsh words 0
Count the Y's in a filtered column that contains Y and N 1
Summary help! 3
Sumif across a table 1
Multiple IF statement 1
I want to be able to input "Y" or "N" and tally them as 1 or 0. 4
Multiple Criteria, Count If, Sum Product to get count across range 5
Converting Letters To Numbers Summary??? 2

Back
Top