Hi, I searched and didn't find much on this. If I missed something my apologies.
I have a working method to count by a column within a date range like so:
However, I'm trying to add a filter to exclude by a few things. So I tried this:
The data in both a:a and othersheet!a:a are both ip address strings. I tried variants by removing the * after the > and the &*
Q:Q is a field with dates in it. AO:AO is the field filtering by a string for inclusion. I tried putting the A:A and OtherSheet filter at the end as well as the beginning just to see if it was an ordering issue.
Ideally I could filter by a combination of two fields. So if a:a is in othersheet!a:a and b:b is in othersheet!b:b then don't count, and if othersheet!a:a has an ip in it but othersheet!b:b has an asterisk it simply ignores everything for that ip, or vice versa with b:b and othersheet!b:b.
I hope I explained this well. This is with o365.
I have a working method to count by a column within a date range like so:
Excel Formula:
=COUNTIFS(Q:Q,"<"&TODAY()-30,Q:Q,">"&TODAY()-89,AO:AO,"*STRING*")However, I'm trying to add a filter to exclude by a few things. So I tried this:
Excel Formula:
=COUNTIFS(A:A"<>*"&OtherSheet!A:A&"*",Q:Q,"<"&TODAY()-30,Q:Q,">"&TODAY()-89,AO:AO,"*STRING*")The data in both a:a and othersheet!a:a are both ip address strings. I tried variants by removing the * after the > and the &*
Q:Q is a field with dates in it. AO:AO is the field filtering by a string for inclusion. I tried putting the A:A and OtherSheet filter at the end as well as the beginning just to see if it was an ordering issue.
Ideally I could filter by a combination of two fields. So if a:a is in othersheet!a:a and b:b is in othersheet!b:b then don't count, and if othersheet!a:a has an ip in it but othersheet!b:b has an asterisk it simply ignores everything for that ip, or vice versa with b:b and othersheet!b:b.
I hope I explained this well. This is with o365.
