Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
question
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
question
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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
question
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot table question | Excel Discussion (Misc queries) | |||
Follow-Up (Clarification) to MIN question | Excel Discussion (Misc queries) | |||
Benefits many people - Question | Excel Discussion (Misc queries) | |||
How do I find and replace a question mark in Excel? | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions |