CODEWITHSUNDEEP
excel-formula
Damian
Damian

Reputation: 1

Excel 2010 Formula to make a count calculation based on two variables

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,

Upvotes: 0

Views: 6386

Answers (1)

assylias
assylias

Reputation: 328598

You can use COUNTIFS (with an s to support multiple conditions) - something like:

=COUNTIFS(A:A,"open",B:B,"<="&TODAY())

Upvotes: 0

Related Questions