Excel.png
I am trying to create a formula that counts a certain value from multiple columns, but only for certain rows based on another condition. In the example data in the picture, i'd want to count the occurrences of a certain task i.e Telephone from columns C to G, but for a particular staff type i.e. Managers. I can't think of a way to apply the count to only the rows matching manager.
Thanks for any help everyone!
Bookmarks