November 26, 2022


Microsoft Excel logo on a green background

First, designate cells to carry “True” or “False” outcomes based mostly on the state of every checkbox. You may then rely up the checkboxes by utilizing Excel’s COUNTIF operate to rely the variety of “TRUE” outcomes.

When you use Excel to create a checklist, you could need to rely the variety of checked or unchecked packing containers. With a easy system, you possibly can tally them in a cell that adjusts as extra packing containers are marked or unmarked.

Designate Cells for the Checkbox Controls

While you verify a field in Excel, the results of the verify is True. For unchecked packing containers, the result’s False.

So, earlier than you create the system to count your checkboxes, you’ll have to designate cells to carry the True or False end result. You’ll then use that lead to your system.

RELATED: How to Count Checkboxes in Google Sheets

Proper-click your first checkbox and choose “Format Management” within the shortcut menu.

Format Control in the shortcut menu

Within the Format Management field that seems, go to the Management tab. Within the Cell Hyperlink field, enter the cell the place you need to show the True or False end result. It’s also possible to choose the cell in your sheet to populate that field.

Click on “OK” to save lots of the change.

Cell reference in the Cell Link box

Observe the identical course of for the opposite checkboxes that you simply need to rely in your sheet.

It’s best to then see the True end result for checked packing containers and False for unchecked packing containers within the designated cells.

Checked boxes displaying True

Notice: When you set the default Worth for the checkbox as Unchecked, it received’t show False until you verify the field after which uncheck it.

Use the COUNTIF Perform

When you have the checkboxes set up, go to the cell the place you need to show the rely.

You’ll then enter a system for the COUNTIF function that shows a rely for both True or False, relying on which you need to rely.

RELATED: How to Use the COUNT Function in Microsoft Excel

For instance, we’re counting the checked packing containers in cells B2 via B11 utilizing their ends in cells C2 via C11. So, you’ll use the end result cells in your system as follows:

=COUNTIF(C2:C11,TRUE)

You may see that we obtained the proper rely of 6 for our checked packing containers.

COUNTIF True for checked boxes

To rely the unchecked packing containers as an alternative, merely change True with False within the system:

=COUNTIF(C2:C11,FALSE)

COUNTIF False for unchecked boxes

Notice: When you set the default Worth for the checkbox as Blended, it won’t rely towards the True or False end result. It displays as #N/A till the field is checked or unchecked.

Optionally available: Conceal the Outcome Cells

It is probably not best to show the True and False ends in your sheet. It could be distracting from the info you need to see.

When you have the ends in a single column or row with out every other knowledge you want, you possibly can merely hide the column or row.

RELATED: How to Hide Cells, Rows, and Columns in Excel

Proper-click the column or row and choose “Conceal” within the shortcut menu.

Hide in the column menu

The system for the checked or unchecked packing containers will work simply the identical with the outcomes hidden.

Results column hidden in Excel

Counting the variety of accomplished duties, incomplete orders, or one thing related is simple to do with the COUNTIF operate and a little bit of checkbox manipulation in Excel.

For extra, try how one can use checkboxes in your Word documents too.



Source link

Leave a Reply

Your email address will not be published.