Need help with Countif date formula

I have a date column, and I want to count the number of "Good Rolls" for that specific date.
I managed to get Shift LBS Produced for the 24th and Total Rolls.
The number 81 in good rolls column reflects the total for all date. How do I get a result for just the 24th, 25th etc.
Answers
-
What did you to do get the other two that are working for you?
-
Hi Mike, are "Good Rolls" coming from another sheet? Does that sheet have multiple rows for a specific date?
You'll most likely want to use SUM and COLLECT, but it's hard to know for sure without knowing more about where good rolls is coming from.
You'll probably want something like this:
=SUM(COLLECT({Good Rolls Range}, {Date Range}, @cell = [Date]@row))
Can you add a screenshot of your other sheet? Then I can help make sure that the Cross-References that I put in the formula are accurate for your other sheet.
Best!
Nathan Braun (Founder of SSFeatures) (nathan@ssfeatures.com) (LinkedIn)
SSFeatures - The browser extension that adds essential features into Smartsheet.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.9K Get Help
- 474 Global Discussions
- 208 Use Cases
- 517 Announcements
- 5.6K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 84 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!