Count Question

[Domearian]

I have 8 columns in each ROW of data, 6 Simply record Yes/No in each column.

At the end of each ROW, I simply want to count the number of Yes in column 7 and number of No in Column 8.

Any ideas? Thought it would be simple but am racking my brains....

[TeeSee1]

IF([col1], 1, 0) + IF([col2], 1, 0) + .. + IF([col6], 1, 0) <<= Column 7

6 - [col7]  <<= Column 8

[Domearian]

Thanks. Not quite sure how this would work if I change the YES/NO to Completed/Not Completed.

So [col1],"Completed","Not Completed"

How would that perform a count?

[TeeSee1 · Accepted solution]

If([col1]="completed",1,0)

[Domearian]

Perfect, I had thought that an array could have done something but that solution is simple and works! Thank you. 🙏