Using COUNTIF and SUMIF with dates
Hi everyone,
I need help understanding how I can use dates in COUNTIF and SUMIF formulas. I have all other parts of the formula working but as soon as I try and add a date condition at all it fails. What I need is something that makes it include all rows where the date in the column Date Closed is the current month.
My current formula looks like: =COUNTIFS({Bus Unit}, "QUARRIES VIC METRO", {RFI STATUS}, "CLOSED", {DATE CLOSED}, "MISSING BIT")
Can anyone help me with what goes in the missing bit?
Thanks
Comments
-
This is a piece of a formula I've used to identify a specific month for conditional formulas:
[Date Range], IFERROR(MONTH(@cell), 0) = 1
Where the = 1 is looking for January. If the Cell is blank, it'll just move on and not toss you an error.
Without testing, your formula would look something like this:
=COUNTIFS({Bus Unit}, "QUARRIES VIC METRO", {RFI STATUS}, "CLOSED", {DATE CLOSED}, IFERROR(MONTH(@cell), 0 =1)
-
If you need a specific date, you would simply use a DATE(yyyy,mm,dd) in place of the MONTH function shown above. The same thing can be said for any other date related functions such as YEAR, WEEKNUMBER, YEARDAY, WEEKDAY, DAY, etc...
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 489 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!