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
- Number to words in excel formula - Guide
- Paint.net measure tool - Guide
- Excel grade formula - Guide
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
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