question

V

vanchi233

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
 
V

vanchi233

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.
 
U

ufo_pilot

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,"")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data consolidation 0
Format column widths from one table to a separate table on same page 1
Adding a comment in a footnote area 1
Formatting templates 7
Populate a table based on check box status 2
Auto populate value from one task to another in MS PROJECT 0
Word VBA - Want to test if Full Name is NOT Present in document 0
Autonumber field in Excel that behaves the same as Access 0

Top