Count IF formula

Kim Michael

I need a formula that will count if days till due are between 0 (today) and the next 7 days AND if the status column is not complete.

This is not working for me.

=COUNTIFS([Days Till Due]@row > 0, [Days Till Due]@row < 8, ([Status]@row = "Complete", "")

Thanks all

David Joyeuse

Hi @Kim Michael

Reading you, those seems to be your criteria for counting. But what is it that you want to count?

Otherwise your formula will look like that:

=COUNTIF({Insert range of what you want to count here}, [Days Till Due]:[Days Till Due], AND(@cell>0, @cell<8), [Status]:[Status], "Complete")

Paul Newcome

Try someting like this...

=COUNTIFS([Days Till Due]:[Days Till Due], AND(@cell >= 0, @cell <=7), Status:Status, "Complete")

Kim Michael

This is on the right track but I only want to count if the status is NOT complete. How do I change it to recognize, NOT "Complete"

Paul Newcome

=COUNTIFS([Days Till Due]:[Days Till Due], AND(@cell >= 0, @cell <=7), Status:Status, @cell <> "Complete")

Kim Michael

You rock! Thank you so much!!!!!

Paul Newcome

Happy to help. 👍️