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!!!
Offer SUMPRODUCT, not refer to whole range
If it does not work, try to upload a samle spreadsheet.
=SUMPRODUCT(('CORE Process Audit data'!$D$1:$F$1000=G5)*('CORE Process Audit data'!$G&1:$G$1000<=TODAY())*('CORE Process Audit data'!$G$1:$G$1000>=TODAY()-30))
Quang PT
On the CORE Process Audits tab, I need B5 to pull the number of audits that match the label in G5 in columns D, E, or F in the CORE Process Audit data tab as well as have a Created date 'CORE Process Audit data'!$G$:$G) within the last 30 days.
I try the formula and it returns 7, exactly with test result (from 28/12/2020-27/01/2021)
What is your desired result?
This is perfect! Thank you so much for the help.
To mark a thread as solved, please select Thread Tools from the menu link above and mark this thread as SOLVED.
You do not need to edit the post title.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Thanks for the help!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks