Count number of checked boxes

I am having issues coming up with a formula in the "red box"that will display a number 1-8 depending on how many boxes are checked with an "x" in cells C2-C8 and then reversing that number.

Example, if 8 boxes are checked, the red box should display 0.
Example, if 0 boxes are checked, the red box should display 8.
Example, if 3 boxes are checked, the red box should display 5.

Thanks in advance
Robert

Please change the title of your thread to something that describes your problem; e.g. "Count number of checked boxes".

You may wish to change your title to something more descriptive, else face the wrath of the moderators.


=COUNTBLANK(range)

Swap "range" for the cells you're looking at, noting that you only have 7 rows that you'd logically be looking at rather than 8.

You may wish to change your title to something more descriptive, else face the wrath of the moderators.



Maybe like this.

Notice you once added 7 boxes, so I added 1 box manualy.

Do you have questions, just ask.