I am trying to create a COUNTIFs for a metric that I need for COVID-19 tracking.

I have a datasheet: LOB, and Record Type

LOB is a drop down

Record type is a drop down either travel or isolation

I want to be able to pair up LOB and the # of employees in isolation (Record Type)


LOB (Corporte) : Record Type = Isolation (3)

Any help would be appreciated.

Best Answer


  • That worked great thank you so much for your help!

  • Andrée StaråAndrée Starå ✭✭✭✭✭


    Happy to help!

    Remember! Did my post help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!


    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

Sign In or Register to comment.