turn the letters N and Y into numbers just for totals
 

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

turn the letters N and Y into numbers just for totals
 

try
=countif(range,"Y")

"Psycho-J" wrote:

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

turn the letters N and Y into numbers just for totals
 

Look at the COUNTIF() function

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Psycho-J" wrote in message ...
|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

turn the letters N and Y into numbers just for totals
 

thanx it worked great. now is there a way to link them to other worksheets???

"bj" wrote:

try
=countif(range,"Y")

"Psycho-J" wrote:

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

turn the letters N and Y into numbers just for totals
 

thank you

"Niek Otten" wrote:

Look at the COUNTIF() function

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Psycho-J" wrote in message ...
|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