Hi all,
Need some assistance with a formula.
Excel attached for sample data.
I need a formula that counts the number of cells from Tab 1 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
Bookmarks