COUNTIFS with 2 data fields and in between 2 specified dates

[TaylorGC]

Hi I was hoping somebody could help with this one, I did get somewhere yesterday however the formula didn't work as it needed it too

I have 2 columns with data that I need it to countifs and then count if it falls between 2 dates that I have in a validation tab it works in periods so period 1 runs from 26/9/20 to 23/10/20

I need the formula to tell me how many actions were raised (date created column) in that period and how many actions were closed (date completed) in the period the data fields as you'll see on the spreadsheet are whether its and high intermediate or low action and if it's one of 3 other fields PIP MH, PIP WPT or PIP RR

essentially I'm asking the sheet to tell me if an action was created on the 10/10/20 and it was high and it was a PIP MH then in the High/MH cell for open it would count 1 and if that action had been closed out in that same period it would also count 1 but in the closed cell for that period

hope that makes sense, I've put some info onto the sheet

[AliGW]

Administrative Note:

Welcome to the forum.

Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

Please see Forum Rule #5 about thread duplication.

I am closing this thread, but you may continue here in the original thread: https://www.excelforum.com/excel-for...n-formula.html