Dividing populated cells against unpopulated cells in data set

**gerst0230** · 02-23-2012, 10:52 AM

Hi, I am trying to figure out how to divide populated cells against unpopulated cells in data set. Example: J3:J10 has 4 X's in it (X being a letter to indicate that a task has been completed). I have a % complete column (which is a merge of J3:J10) and I am trying to find a function to show me how far complete I am in a project that has multiple tasks. Is there a way to divide X by blank cells?

Thanks in advance,
Matt

**sweep** · 02-23-2012, 10:55 AM

Hi.

Does this work for you?

=COUNTIF(J3:J10,X")/COUNTBLANK(J3:J10)

**gerst0230** · 02-23-2012, 12:12 PM

Hi, thanks for your help! That formula is giving me a result of 60%, whereas I have 3/8 of my cells populated or 38%. I'm looking into seeing if I can figure it out but if you can offer any more advice I'd greatly appreciate it. Thanks!

**gerst0230** · 02-23-2012, 12:24 PM

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?