question

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

Guest

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
 
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.
 
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,"")
 
Back
Top