Hi all,
Need some assistance with a formula.
Data (Tab 1)
Report (Tab 2)
I need a formula that counts the number of cells and puts it in Tab 2 'B2' that match the following:
1. Date (A2-A6) is within October 2020 (ie Oct-20), AND
2. Status is either Received or "In Progress" or "Requested"
So in this case the answer should be 3.
Any assistance would be greatly appreciated.
I am using O365.
Rgds,
AW 2020
Need some assistance with a formula.
Data (Tab 1)
A | B | |
1 | Date (DD/MM/YY) | Status |
2 | 11/09/20 | Received |
3 | 01/10/20 | Reviewed |
4 | 15/10/20 | In Progress |
5 | 16/10/20 | Requested |
6 | 10/10/20 | Received |
Report (Tab 2)
A | B | |
1 | Month | Number Active |
2 | Oct-20 |
I need a formula that counts the number of cells and puts it in Tab 2 'B2' that match the following:
1. Date (A2-A6) is within October 2020 (ie Oct-20), AND
2. Status is either Received or "In Progress" or "Requested"
So in this case the answer should be 3.
Any assistance would be greatly appreciated.
I am using O365.
Rgds,
AW 2020