COUNTIFS or other appropriate formula

RICHIE GRIFFIN

Hi,

I'm attempting to create a count of the occurrences of text in a column called 'DOCTOR' from a list of drop downs in rows 2 to 32 inclusive:

FULL DROPDOWN LIST:

CLINIC 1

CLINIC 2

CLINIC 3

NOT ROSTERED

ON COMPANY BUSINESS

UNPAID SICK DAY

UNAVAILABLE

I'd like to get an automated count of the instances of the following:

CLINIC 1

CLINIC 2

CLINIC 3

ON COMPANY BUSINESS

Can somebody assist me by providing the correct formula?

Many thanks.

Regards,

Richie

 

Mike L.

I don't follow what the sheet looks like. Can you make a new sheet with just the basics (no sensitive or company data) and post a link to that sheet?

RICHIE GRIFFIN

Thanks for the prompt response Mike. Here's a link to the test sheet: TEST SHEET  

The cells that require formulas are highlighted orange. Note the European date format DD/MM/YY!

Regards,

Richie

Andrée Starå

Hi Richie,

Did you get it working with my recommended setup?

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting