Formula to measure percent of checklist complete
Closed
jlmetzger
TrowaD
- Posts
- 1
- Registration date
- Monday January 14, 2013
- Status
- Member
- Last seen
- January 14, 2013
TrowaD
- Posts
- 2880
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- May 2, 2022
Related:
- Formula to measure percent of checklist complete
- Unable to complete request messenger ✓ - Forum - Facebook Messenger
- Spreadsheet formula - Articles
- How to disappear completely from the internet - Guide
- Messenger problem - Forum - Facebook Messenger
- Excel @ in formula ✓ - Forum - Excel
1 reply
TrowaD
Jan 14, 2013 at 10:31 AM
- Posts
- 2880
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- May 2, 2022
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