I think I figured out the issue(s), the first is the title of my thread - it's misleading and I apologize for that - I am looking for the populated cells divided against the total number of cells in the cell set. The formula that you gave is correct but it unfortunately only divides against the populated cells, instead of the total cells, which is giving me 60% instead of the goal of 38%. Is there a function to accompany all cells (blank and nonblank) in the set?
Bookmarks