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 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 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 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
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