count if greater than or equal to 50% and lesser than or equal to 75%

[Anonymous]

Hi,

Below is my data. I would like to count the date entries if the In Octets % is greater than or equal to 50% and lesser than or equal to 75%. The result has to be 4. Please help to achieve the expression.

[MK_QSL · Accepted solution]

=COUNT(DISTINCT IF([In Octets %] >= 50 and [In Octets %] <=75,Date))

[robert_mika]

=Count({$< [In Octets %] = {">=50<=75"}>} DISTINCT Date)