Need help with Countif date formula

Mike Curry

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.

Paul Newcome

What did you to do get the other two that are working for you?

SSFeatures

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!