Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi I have a quick question.
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.
Maybe it has to do with my data then. I'll take a closer look. Thank you!
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.
The null values in the dimensions are excluded as well