CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formula
SAR622
SAR622

Reputation: 637

Counting unique values in a column only when a different column has a criteria

I have a form submitting responses to a Google Sheet. Each response is a name and a date. I want to count the number of unique responses I got today.
Currently, I am able to count the responses for today but if Alex submitted the form twice, I count him twice. (for other reasons, I know that name values are unique.)
My current formula is below and I'd like to know how to adjust it. If it's helpful, here's a link to a sample spreadsheet with mock data. See cell B4 on the sheet "Count of Responses"

=ArrayFormula(SUMPRODUCT(1*INT('Form Responses'!C$2:C)=datevalue(B1)))

Upvotes: 1

Views: 61

Answers (1)

Marios
Marios

Reputation: 27350

Try COUNTUNIQUEIFS:

=COUNTUNIQUEIFS('Form Responses'!$B$2:$B,'Form Responses'!$C$2:$C,B1)

Upvotes: 2

Related Questions