Sumifs returning #unparseable counting RAID due within 7 days

jmacdal

Hello - Receiving an #unparseable error when counting RAIDs due within 7 days. screenshot of the columns status and due date.

Formula -

Paul Newcome

The most immediate issue is the closing parenthesis after the [Due Date]:[Due Date] range. It needs to be removed.

If you are trying to get the count for within the next 7 days, this should work for you:

=COUNTIFS(Status:Status, @cell <>"03 Closed / Deferred", [Due Date]:[Due Date], AND(@cell<=TODAY(+7), @cell>= TODAY()))

Samuel Mueller

@jmacdal Try this formula, why do you have And? Do you need more criteria's?

=COUNTIFS(Status:Status, <>"03 Closed / Deferred", [Due Date]:[Due Date], >=TODAY(+7))

DKazatsky2

Hi @jmacdal ,

You don't need the @cell reference. Try this.

=COUNTIFS(Status:Status, <>"03 Closed / Deferred", [Due Date]:[Due Date], >=TODAY(7))

Hope that helps,

Dave

Paul Newcome

The most immediate issue is the closing parenthesis after the [Due Date]:[Due Date] range. It needs to be removed.

If you are trying to get the count for within the next 7 days, this should work for you:

=COUNTIFS(Status:Status, @cell <>"03 Closed / Deferred", [Due Date]:[Due Date], AND(@cell<=TODAY(+7), @cell>= TODAY()))

jmacdal

Thank you, all. Samuel and Dave got rid of the error but returned 0 count, which there were 11. Paul's returned the correct total of 11.

Samuel Mueller

Makes sense given the need, glad you got it working!

Paul Newcome

Happy to help. 👍️