CODEWITHSUNDEEP
arraysgoogle-sheetsbooleangoogle-sheets-formulacountif
Sercan Samet Savran
Sercan Samet Savran

Reputation: 945

Google Sheets' COUNTIF doesn't function with boolean values

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.

Upvotes: 2

Views: 3057

Answers (1)

player0
player0

Reputation: 1

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

=COUNTIF(A1:A100; TRUE)

0

Upvotes: 1

Related Questions