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