Excel 2010 on Window 7
I'm struggling to find a formula which will count the number of open and overdue actions in a project tracker. This would be on the summary tab
The formula would need to to check the tab called 'actions' and make a count calculation based on the following variables:
1) In each row in column A the cell has 'open' populated (options for this are 'open' and closed'
2) For each action that has 'open' specified in Column A it would also need to check the action due date in column J. If this date is overdue then this action would need to be counted.
I have tried a COUNTIF formula but it is only calculating overdue actions and ignoring if they are action is open or closed.
Any help you can provide will be much appreciated.
Kind Regards,
