Percent Complete from an External Reference
I'm working on a project plan for work and have external references to another sheet. I'd like to accomplish a count or countif function to help me with the below:
If "Column X" = "Y" then count the sum of "Y" in that column and divide it by the total rows for a percentage complete.
Meaning, I want to count the amount of "Y"s listed in a column and turn it into a percentage based on the total sum of the items in the column.
I'm sure this was terribly explained so I apologize in advance and appreciate any and all help!
Help Article Resources
Check out the Formula Handbook template!