Count how many in the sheet

Options

I want to count how many instructors we have that a value in Client to get a total.

there are different clients in the client column



Answers

  • Nick Korna
    Nick Korna ✭✭✭✭✭✭
    Options

    Hi @Louis.Smith,

    I think your Client column is a dropdown allowing multiple selections, so this formula should work for calculating the number of instructors at a particular company:

    =COUNTIF(Client:Client, HAS(@cell, [Metrics Total]@row))

    For the total, you can either sum the COUNTIFS, or if you just want a count of how many instructors there are regardless of how many companies they cover then just use =COUNT(Client:Client)

    Sample:

    Hope this helps - if I've missed something or you've any other questions then just post! 😊

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Options

    Are you wanting to count how many instructors there are for a specific client?

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!