Hello!
I want to use COUNTIFS but apply the formula only on the last 7 days.
That's the formula I'm trying to use and the data sheet I have, I might need to format that data (?) but my attempts got quite unsuccessful.
I want to use COUNTIFS but apply the formula only on the last 7 days.
That's the formula I'm trying to use and the data sheet I have, I might need to format that data (?) but my attempts got quite unsuccessful.
Excel Formula:
=COUNTIFS('results-20230321-152509'!D:D,"android",'results-20230321-152509'!BC:BC,B2,'results-20230321-152509'!N:N,"__SESSION__",'results-20230321-152509'!A:A,">="&TODAY()-7)
Attachments
Last edited by a moderator: