CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formulaspreadsheet
coffee709
coffee709

Reputation: 77

Google Sheets / COUNTIF value is X and date is TODAY

I have a long list of dates in column C with a long list of names in column D.

I need to count how many times a certain name is mentioned but only if the date next to it is today.

So if today's date is 16/11/2022, and I want to find the name "Peter", this formula should return "2".

Column C Column D
16/11/2022 Peter
16/11/2022 Peter
17/11/2022 Peter

Any ideas? Thanks!

Upvotes: 1

Views: 910

Answers (1)

player0
player0

Reputation: 1

use:

=COUNTIFS(C:C; TODAY(); D:D; "Peter")

enter image description here

update:

=INDEX(COUNTIFS(INT(C:C), TODAY(), D:D, "Peter"))

enter image description here

Upvotes: 2

Related Questions