Previous Topic Next Topic

Formula to measure percent of checklist complete

[Closed]
Report
Posts
1
Registration date
Monday January 14, 2013
Status
Member
Last seen
January 14, 2013
 -
Posts
2818
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 18, 2021
 -
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

Answer 1 / 1
Posts
2818
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 18, 2021
 486
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
Ask a question