I have a list of closed dates and I am wanting a count by specific month. The problem is that for January it counts every blank as a record in January.
=SUM(IF(MONTH(tblDashboard[Closed])='R1 Dashboard'!$D$12,1))
I was also trying it this way but cannot tell it which month to choose from.
=COUNTIF(tblDashboard[Closed],"<>"&"")
Any help would be appreciated.
=SUM(IF(MONTH(tblDashboard[Closed])='R1 Dashboard'!$D$12,1))
I was also trying it this way but cannot tell it which month to choose from.
=COUNTIF(tblDashboard[Closed],"<>"&"")
Any help would be appreciated.