Formula to measure percent of checklist complete

Closed
jlmetzger
Posts
1
Registration date
Monday January 14, 2013
Status
Member
Last seen
January 14, 2013
- Jan 14, 2013 at 09:49 AM
TrowaD
Posts
2880
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 2, 2022
- Jan 14, 2013 at 10:31 AM
Hello,

I am trying to build a checklist where if you have completed the task on the list, you put an X in the cell below that task. As tasks are marked complete with the X, a cell at the end of the row containing the "X"s would add 1 to the sum. In other words, if I have added 5 X's to the list and there are 10 total, the cell at the end would have 5 in it. If I add an x to another completed task, it would change to 6 and if I delete an x it would go back to 5. Make sense? Thanks in advance.

My ultimate goal is to grab all the sum cells and figure a total % complete by combining several lists using this approach.

1 reply

TrowaD
Posts
2880
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 2, 2022
509
Jan 14, 2013 at 10:31 AM
Hi Jlmetzger,

So to summarize you would like to count the number of X's in a row.

Use this array formula:
=SUM(IF(A5:J5="X",1,0))

Array formula's needs to be confirmed by hitting Ctrl+Shift+Enter.
If done correctly the formula will be enclosed in curly brackets {}.

Or you can simply use:
=COUNTIF(A5:J5,"X")

The choice is yours.

Best regards,
Trowa
-1