LinkBack URL
About LinkBacks
I am able to use =Countif('CORE Process Audit data'!$D:$F,G5) and =COUNTIFS('CORE Process Audit data'!$G:$G,"<="&TODAY(),'CORE Process Audit data'!$G:$G,">="&TODAY()-30) separately, but I cannot figure out how to use them in one COUNTIFS statement.
I am able to use =Countif('CORE Process Audit data'!$D:$F,G5) and =COUNTIFS('CORE Process Audit data'!$G:$G,"<="&TODAY(),'CORE Process Audit data'!$G:$G,">="&TODAY()-30) separately, but I cannot figure out how to use them in one COUNTIFS statement.
Last edited by AliGW; 01-27-2021 at 11:44 AM. Reason: SOLVED tag added - no need to edit the thread title!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks