M
MythicZohar
I have a workbook that has 3 sheets.
There is a list sheet that contains listed data in separate columns
that is validated or used in drop downs in a separate sheet. I am
working with 2 columns,1 that contains a list of RN names and the 2nd
is a list of activities
There is a 2nd sheet to allows the user to select their name under
column "RN, and select an action category in a separate column.
There is a report sheet that contains countif and sumif formulas.
Below is the formula I am working with
=COUNTIF(RN,Lists!B2)
Here's the question. If the list contains 6 values, for the RN listed
in B2
cases, class, learn, burn, jump, phone
is there a way that I can alter the formula to return only specific
values, while still allowing the user to validate all 6 values?
In other words lets say I only wanted to have the report sheet to
return
how many; cases, class, phone the RN handled?
Any help would be appreciated
There is a list sheet that contains listed data in separate columns
that is validated or used in drop downs in a separate sheet. I am
working with 2 columns,1 that contains a list of RN names and the 2nd
is a list of activities
There is a 2nd sheet to allows the user to select their name under
column "RN, and select an action category in a separate column.
There is a report sheet that contains countif and sumif formulas.
Below is the formula I am working with
=COUNTIF(RN,Lists!B2)
Here's the question. If the list contains 6 values, for the RN listed
in B2
cases, class, learn, burn, jump, phone
is there a way that I can alter the formula to return only specific
values, while still allowing the user to validate all 6 values?
In other words lets say I only wanted to have the report sheet to
return
how many; cases, class, phone the RN handled?
Any help would be appreciated