I have a single program plan made up of 3 separate projects (that do have dependencies between them). I have been asked to count the number of times resources appear in each plan. While I have been able to create a simple formula if I only need to count one resource group at a time, now I need to count multiple resource groups so that they are combined into one over arching group. For example, I have been asked to show how many tasks IT works on. The problem is that in the Resource column IT could be someone from Server, Database, or Desktop. How do I create a formula that counts those various IT resource groups into one main group (IT) and then for each specific project? The formula I created for the easy resource, such as PM worked fine:
=COUNTIFS([Project Name]:[Project Name], "House", Group:Group, HAS(@cell , "Project Manager"))
But how do I now add multiple criteria to that second function? I am thinking that it still needs HAS but also AND?? So instead of Project Manager, I need Server AND Database AND Desktop. The number I'm looking for is 30 if Server = 10, Database = 10 and Desktop = 10.
