#IMPARSEABLE error message a column with specific date from another column

My goal is to collect all of column "Estimated # of grp mem (not including fac)" for dates that begin 1/1/23 and after which are located in column "Date Form Completed".
I've tried it with COUNT and COUNTIFS without success. Is there a piece I am missing?
=COUNT(([Estimated # of grp mem (not including fac)]:[Estimated # of grp mem (not including fac)], [Date Form Completed]:[Date Form Completed], >=DATE(2023, 1, 1))
Thank you!
Answers
-
Can you provide a screenshot fo the formula open in the sheet as if you are about to edit it?
-
Try a COUNTIFS with only the date range/criteria set.
=COUNTIFS([Date Column Name]:[Date Column Name], @cell >= DATE(2023, 1, 1))
-
Formula no longer creates error message but does not pull the data.
-
I also tried exactly as you had it laid out in the formula using the name of the Date Column Name.
This was IMPARSEABLE.
-
Try removing the closing parenthesis from after the "completed" in the second column reference.
-
Removing the ) gave me the number of rows since 1/1/23
So I added in the criteria for the "Estimated # of grp mem (not including fac)" so I can get the sum of that column with only the 1/1/23> dates. Still IMPARASEABLE.
=COUNTIFS((SUM=[Estimated # of grp mem (not including fac)]:[Estimated # of grp mem (not including fac)]) [Date Form Completed]:[Date Form Completed], @cell >= DATE(2023, 1, 1))
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!