CountIfs Date Range
Hello! I'm trying to pull the line count on another sheet if the line's completion date is within the start and end date of another sheet. My formula is returning 0 and I'm not quite sure where the issue is coming from.
=COUNTIFS({Accuracy Issue Tracker with Form Range 3}, [Billing Date Start]:[Billing Date Start] <= {Accuracy Issue Tracker with Form Range 4}, {Accuracy Issue Tracker with Form Range 3}, [Billing Date End]:[Billing Date End] >= {Accuracy Issue Tracker with Form Range 4})
Thank you!
Answers
-
Give this a try:
=COUNTIFS({Accuracy Issue Tracker with Form Range 4}, @cell<= [Billing Start Date]@row, {Accuracy Issue Tracker with Form Range 3}, @cell>= [Billing Date End]@row)
-
Hey Paul!
I used the formula above but am now getting #UNPARSEABLE. Any suggestions?
Thank you!
Elizabeth
-
@Elizabeth Smiley23 It looks like your syntax is off. Did you try my formula as is?
-
Hey,
I copied and pasted it as is. Below is a screenshot of your comment and the formula side by side. I'm not seeing a difference, but I may be missing something.
-
It looks like it is not registering the column names as valid. Double check the column names in the formula match what is actually used in your sheet.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.7K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!