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
2758
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 17, 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

Posts
2758
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 17, 2021
462
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!