Count Checked Checkboxes in Excel | Sum if Checkbox is Checked | Formula to Count Checked Checkboxes

In this Microsoft Excel video tutorial I demonstrate two ways of counting or summing checked checkboxes. The first method uses checkbox controls and is the method to use if you have a small number of checkboxes. The second method uses the CHAR function and a VBA macro; this method is useful if you need a large number of checkboxes.

Both methods use COUNTIF and SUMIF.

Table of Contents:

00:00 - Introduction
00:21 - METHOD 1: Using checkbox controls
03:10 - METHOD 2: Using the CHAR function & VBA
------------------------

[electricblueeyes]

there's this feeling of satisfaction on understanding formulas

[glzoyfb]

Thank you for your Tutorial Vid, it's so simple and easy to use.

[igotyuu]

I really have to say thanks for your video, I had try a lot to find this to solve my problems.

[IvanCortinas_ES]

Great video. Excellent composition of the solution with the use of the CHAR function.

[hh]

Superb tutorial! Very clear and informative🤩

[Robbiea]

Thanks so much! No one ever adress the checkbox copy problem. It is first solution i See on YT. Very creative and easy. I hope maybe one day MS will improve auto copy for checkboxes in patch. Any way thanks

[MikedWilson]

Hi great Video, it came in handy for what i am doing. I do have a question though I am using this method in a table which auto updates getting the data from a sharepoint list, columns G-L are the only columns that get the data from sharepoint and I have the checkbox in row M (using the VBA Code) however when I update data, its ticking all the checkboxs on the table, do you know how I prevent this and get it to leave the checkboxes as they are when the table updates

[Aleks]

Hello, thank you for the videos. I used your Attendance tutorial and whend I paste formula into a Conditional formatting it did not work. Although it did work inside the spreadsheet itself showing True and False on weekdays. Formula I use was corresponding to yours: =OR(WEEKDAY(H$8, 11)=6, WEEKDAY(H$8, 11)=7, COUNTIF(Holidays_dates, H$8)=1, H$8=""). In my case it was H8. Please advised. Thank you.

[mandysandysosa]

I have a table with check boxes using your second method. I would like only the value of the checked cells to show in another column how do I get to do that I know there must be some link with the checked cell and the cell I want it to show but not sure how too. I have a total of 100 cells

[rsavitri]

Doesn't work on Mac as Char 254 in Windings provides different character :(

[Atudo.]

I have a question. I’m working on one project and I don’t find the right formula for check boxes. Example: let’s take numbers from 1 to 20 and alocate 2 colours ( orange for odd and green for even ) and we have 4 results where need to stock data ( 1 to 10 = low / 11 to 20 high ) and we have box1 = low even green / box2 = low odd orange / box3 = high even green / box4 = high odd orange. When tick a box on number 1 for example, need in box1 = 1 but tick need to be gone after marking it and then let’s say we select 7, in box1 = 2 … sum and count formulas are not working unless I miss something. Is there any coding that needs to be ajusted ?

[Acme]

How can i make the chekbox activa with single click?

[rtrbs]

Thank you but VBA code is not in description and It is not working for me as I double click it still entering Edit mode

[p-cwixstrom]

Hey, the =char(254) does not work for me. Using Office365.. Any advice on this?

[Srrcav]

why cant you do =COUNTIF(xx:xx, CHECKED)