Sign in to join the conversation:
Would anyone have a example of a formula to count checked boxes in a column divided by the number of unchecked boxes. Any help will be greatly appreciated. Thanks.
This should do the trick. Checkboxes use the actual value of 1 for checked and 0 for unchecked. You can divide the two countifs with simple math like seen below.
=Countif([column name]:[Column Name], 1) / Countif([column name]:[Column name], 0)
So if your column name is Completed Task then it would look like this:
=Countif([Completed Task]:[Completed Task], 1) / Countif([Complete Task]:[Complete Task], 0)
Thank you so much, that works perfect. Now I need to divide by the total number checked by the total number of boxes containg both checked and not checked. I'm so close but no cigar at this point. Any suggestions?
wouldn't it just be
=Countif([column name]:[Column Name], 1) / (Countif([column name]:[Column name], 0) + Countif([column name]:[Column name], 1))?
Also, the denominator is basically all so you could do a count rather than a countif ... but I think this formula is what you were describing
The formula dividing the total number into the number of checked is...
=countif([column name]:[column name], 1) / count([column name]:[column name])
The count function counts all unblank cells in the range.
I have one sheet that is tracking PTO where a user has entered the days off. The form allows them to enter a start and end date for their PTO and enters a single record into the sheet. I have a second sheet that I am looking to pull that data into, but there is only one record per person (column in this sheet where the…
I am trying to get the passenger count per month per year, and I can't seem to get the formula correct. I need to add the number of passengers for each month per year. If anyone could assist me with this, I would greatly appreciate it. Thanks!
Date Report Partner CBO Name 01/12/25 Children's org 05/15/25 Foodbank 08/30/25 Children's org 09/11/25 Chamber 11/25/25 Digital Bus 08/21/24 Digital Bus South 01/15/26 Children's org 01/12/24 Foodbank Sister 02/15/24 For the children org 07/01/26 Digital Bus #2 08/05/26 Family Center 12/01/26 Family Center I am trying to…
