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
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022  Jan 14, 2013 at 10:31 AM
Related:
 Formula to measure percent of checklist complete
 Could not complete this operation. there was not enough memory available  Guide
 Logitech formula vibration feedback wheel driver  Download  Drivers
 Date formula in excel dd/mm/yyyy  Guide
 Number to words in excel formula  Guide
 Position formula in excel  Office Software Forum
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Jan 14, 2013 at 10:31 AM
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
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