Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Count, sum, average
I use Smartsheet to track employee certifications. I'd like to determine the average number of certifications per person at each site/area. I'm able to use an equation to determine the number of certifications each person has, but that occurs in each row which throws off the average. In other words, =IF(Status1 = "Inactive", 0, COUNTIF(EmpNumber:EmpNumber, EmpNumber1))
The above formula gives me the numbers, but the problem is that if someone has 10 certifications, they would have 10 - 10's in that column which would throw off the average.
I am not sure what I need to do with this information to get an accurate ratio of certifications per person. I appreciate anyone's assistance with this.