Say Names are in column A of sheet1
"Y" and "N" are in column B of sheet1
then this can go on the other sheet where you want them to show if they have
a "Y" next to them

=IF(Sheet1!B1="Y",Sheet1!A1,"")



"vanchi233" wrote:

what i mean is this I have a colum Employee Name a4:a50 and I want the
spreadsheet to add these employees so long their "active status" column reads
"Y" for yes.

"vanchi233" wrote:

I created a template and would like to add total names from top to bottom on
one column but based on a criteria from another column