Google Sheets' COUNTIF doesn't function with boolean values

0
votes

I'm looking for the equivalent of the COUNTIF(A1:A100;TRUE) formula of excel, which won't happen to function in google sheets. Had already tried to SUM(--(A1:A100)), neither this doesn't seem to do the job.

The above-mentioned formulas do function in excel/numbers, but in google sheets. Google sheets outcome is zero for this formula.

Edit: Created a copy of the sheet and published -> Google Sheet

Edit2: Was my fault... I used the german expression SUMIF() instead of COUNTIF(). Sheets should definitely not have multilingual expressions -.- Credits goes to @AnonymesEinhorn. Thank you.

1
arraysgoogle-sheetsbooleangoogle-sheets-formulacountif
Are you sure the values in Google Sheets is the Boolean TRUE and not text? - Scott Craner
Try =COUNTIF(A1:A100,"True") - Scott Craner
Yes the values are booleans, since these are generated values with a formula. Even checked to multiply one of the values with =A1*1 and the result is 1, so they have to be booleans. Neither =COUNTIF(A1:A100; "True") does the trick... - Sercan Samet Savran
share a copy of your sheet pls - player0
=countif(E:E;true) works on the test sheet you provided. - Scott Craner

1 Answers

1
votes

not sure how you getting those booleans but it works with text and even checkbox:

=COUNTIF(A1:A100; TRUE)

0