I am currently working on a sheet with a series of projects listed. Each project has a number of people working on it. I have the project names and the people who are working on them as Dimensions on a pivot table. I need to add a column that allows me to count how many people there are working per project. I tried using the aggr() function, if statements, in addition to a few other features. I cannot seem to figure out how to do this.
This formula works, but it also factors in the '0' values. I went into add ons and exluded values that are 0 but this does not seem to make a difference.
This formula works, but it also factors in the '0' values. I went into add on's and excluded values that are 0 but this does not seem to make a difference.
