turn the letters N and Y into numbers just for totals

[Psycho-J]

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

 

[bj]

try
=countif(range,"Y")

 

[Niek Otten]

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

 

[Psycho-J]

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

 

[Psycho-J]

thank you