COUNTIF and Data Validation

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
 

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

Top