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!!!!!
-
Happy to help. 👍️
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 466 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives