Count IF formula

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
Answers
-
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")
-
Try someting like this...
=COUNTIFS([Days Till Due]:[Days Till Due], AND(@cell >= 0, @cell <=7), Status:Status, "Complete")
-
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"
-
=COUNTIFS([Days Till Due]:[Days Till Due], AND(@cell >= 0, @cell <=7), Status:Status, @cell <> "Complete")
-
You rock! Thank you so much!!!!!
-