Count how many in the sheet

Louis.Smith

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

Nick Korna

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

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