CODEWITHSUNDEEP
dategoogle-sheetsgoogle-sheets-formulacountif
Felix
Felix

Reputation: 5619

Countif and logical operation in Google Sheets

In My spreadsheet, I want to count how many invoices are not paid and overdue. So for that I Count tose who are not paid like this:

=COUNTIF(F4:F256, "nein")

But how can I make a condition only count if "date" is lower than today? Normally I would iterate over it but don't know how in the spreadsheet.

The table looks for example like this:

enter image description here

Upvotes: 2

Views: 457

Answers (1)

player0
player0

Reputation: 1

try it like this:

=COUNTIFS(F4:F256; "nein"; E4:E256; "<"&TODAY())

Upvotes: 1

Related Questions