indiemusicboy
New Member
- Joined
- Apr 9, 2020
- Messages
- 47
- Office Version
- 365
- Platform
- MacOS
Hello. First time poster, long time lurker.
I'm working on a formula in worksheet A to pull data from worksheet B in the same workbook.
I have a formula that counts the entries if it meets a keyword criteria from a survey:
=COUNTIF('Data_Delivery Team'!J:P,"Very Satisfied")
... which works fine. But now...
I want to add an additional criteria that only gives me the counts of that formula above - if in the last 30 days:
=COUNTIFS('Data_Delivery Team'!B2:B6, "<"&TODAY()-7, 'Data_Delivery Team'!J:P,"Very Satisfied")
... but that formula is giving me a VALUE error.
Column B = Dates submitted
Columns J-P = Survey input
I'm working on a formula in worksheet A to pull data from worksheet B in the same workbook.
I have a formula that counts the entries if it meets a keyword criteria from a survey:
=COUNTIF('Data_Delivery Team'!J:P,"Very Satisfied")
... which works fine. But now...
I want to add an additional criteria that only gives me the counts of that formula above - if in the last 30 days:
=COUNTIFS('Data_Delivery Team'!B2:B6, "<"&TODAY()-7, 'Data_Delivery Team'!J:P,"Very Satisfied")
... but that formula is giving me a VALUE error.
Column B = Dates submitted
Columns J-P = Survey input