Count if

[luisitocarrion1900]

This is what i have for example if in the Activity Columns it says AI Notices and the out date column have a date it should count it and when a date is added to the return date column the count come off because then it will be counted under return

=COUNTIF(List[Activity],Category1,List[Out Date])

 

[Fluff]

Myabe
=COUNTIFS(List[Activity],Category1,List[Out Date],"<>",List[Return date],"")