Hi guys,

I've searched the forum but can't find the solution to the issue I have.

I am trying to get the number of projects finished on time.
I tried with formula =COUNTIFS(M8:M101;"Zaključen";N8:N101;"<="&F8:F101) but don't get the result.

In column M is the status of project, column N contains finishing date and column F the due date.
I'd like to count the cells where the project status is finished (Zaključen) and the finishing date (N) is less or equal to due date (F).

Your help is much appreciated.

Project status.jpg