x
• Status: Solved
• Priority: Medium
• Security: Public
• Views: 330

# Excel - Calculate the percentage of cells that contain data

Hi,

I need to calculate the percentage of cells that contain data for rows and columns.  I've labeled the row and column and Percent Complete.

Master-List.xlsx
0
REBIC
1 Solution

Commented:
Suppose you wanted to check the % complete for, say, A2:M2.

This is one formula:

=COUNTA(A2:M2)/COLUMNS(A2:M2)

Be advised that it will count a cell that has a formula, even if that formula evaluates to a zero length string.

If you need to exclude all empty cells, as well as cells whose values are zero length strings, you'd use an array formula like this:

{=SUM(IF(A2:M2<>"",1,0))/COLUMNS(A2:M2)}

To enter an array formula, do not enter the curly braces, and hit Ctrl+Shift+Enter instead of Enter to finish it off.  Excel will then display those braces to indicate that it's an array formula.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.