Hi -

Can you please help me, I'm suppose to create a formula that counts the number of row in Column B ranges from 5 - 10 for Column A that is marked 'Pending'.

Here's the table:

1 Column A Column B
2 Pending 10
3 Pending 3
4 Overdue 2
5 Pending 5
6 Overdue 2
7 Overdue 2
8 Overdue 2
9 Completed 5
10 Pending 1
11 Overdue 0
12 Pending 1
13 Pending 0
14 Pending 0

In this example, I should be getting 2.

Thanks in advance.