John SiracusaJul 1, 2023

Google Sheets defeated me this morning. Can any Sheets experts hop into this document and tell me where I went wrong? Please look at "Sheet1" to see the problem. https://docs.google.com/spreadsheets/d/162axdyEkLjugxdTO23us07dytoDsASrdXNgG1gRbBDI/edit?usp=sharing

(After being spurned by the accursed spreadsheet, I retreated to good old-fashioned programming to resolve the situation, as usual. Yes, with Perl.)

Formula Test

Form Responses 1 Timestamp,Are you currently an ATP member?,Tier List 7/1/2023 9:20:10,Yes,2 7/1/2023 9:20:35,Yes,3 7/1/2023 9:20:45,Yes,2 7/1/2023 9:21:06,Yes,2 7/1/2023 9:21:10,Yes,3 7/1/2023 9:21:11,No,2 7/1/2023 9:21:23,Yes,3 7/1/2023 9:21:26,Yes,2 7/1/2023 9:21:34,Yes,1 7/1/2023 9:21:43,No,...

Google Docs
Show threadJohn SiracusaJul 1, 2023

Some approaches that work have been found. One uses QUERY() https://fosstodon.org/@jamesnvc/110640631675785694

Another adds ARRAYFORMULA() around my whole formula, which also works.

Still no explanation why the formula I'm using works for one row but not for another, though!

James Cash (@[email protected])

@[email protected] using `QUERY` instead of countif seems to work: =QUERY('Form Responses 1'!B:B, "select count(B) where B = 'No' label count(B) ''", 1)

Fosstodon
Show threadJohn SiracusaJul 1, 2023
Also, this Google Sheet is rapidly succumbing to The Tragedy of the Commons…
Show threadGeoff Green
@siracusa
Jul 1, 2023 at 8:24pmWeb