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.Please Login or Register to view this content.
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.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
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)
Bookmarks