Count totals in an entire colummn with Checkboxed value

Linda Xie

I have a file with a column containing values with the Orange color selected in the checkbox showing as below.  I want to get the total counts to count the Orange colored ones only (e.g.4 out 6). The formula I tried to use is: =Countif({boxcolum name}:{boxcolum name},1) or =Count({boxcolum name}:{boxcolum name} but only got returned invalid values from either formula. 

Can anyone help?

Thanks,

Linda

John Shane

@Linda Xie

Are you trying to do this on the sheet summary? If so, square brackets around your column name should fix the problem. The formula below should work once you replace Column Name with the name of your column.

=COUNTIF([Column Name]:[Column Name], 1)

Cheers,

John

Linda Xie

Hi John,

I used COUNTIF same as your formula above by referencing another sheet as: =Countif({boxcolum name}:{boxcolum name},1) but got an error result. 

Yes,the formula =COUNTIF([Column Name]:[Column Name], 1) worked with the Sheet Summary but it needs to take some extra steps to link the value from the Sheet Summary into another sheet, which I really try to avoid. 

I just want to figure out how the checkbox formula works by referencing another sheet. Any idears?

Thanks,

Linda