Google-sheets – COUNT value in column A + filter column B & C + > & < value column D (date)

google sheets

I need to calculate how many rows in a range(>= <= of VALUE in column D( date value where every row has own date):
VALUE in column A(if duplicate count as 1), same VALUE in column B, same VALUE in column C.

Spreadsheet link

VIEW EXAMPLE

Best Answer

The locale of your spreadsheet is Italy. This implies that comma is used for separating the fractional part of a number, as in 3,14. Hence, the semicolon is used to separate the arguments of a command. Replacing the commas with semicolons in your formula is all that's needed; 

=COUNTA(UNIQUE(FILTER( $A3:$A9 ; $C3:$C9="B"; $B3:$B9="R5"; $D3:$D9>=C11; $D3:$D9<=C12)))

Additionally, the formula can be slightly simplified by using countunique: 

=COUNTUNIQUE(FILTER( $A3:$A9; $C3:$C9="B"; $B3:$B9="R5"; $D3:$D9>=C11; $D3:$D9<=C12))
Related Topic