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 threadklassobanierasJul 1, 2023
@siracusa seems like a job for COUNTIFS
Show threadJohn SiracusaJul 1, 2023
@klassobanieras Yes, that's what I'm using. It works for one row but not for the other.
Show threadklassobanieras
@siracusa nope you were using countif + if (unless someone edited the formula)
Jul 1, 2023 at 8:22pmWeb