Dcount that omits hidden cells or cells with specific text i.e. "closed"

Hello all,

I'm new to posting on here but have been using the forum for help for a long time.

I find myself with an issue that I don't seem to be able to fix. I have a number of DCOUNT functions working in a sheet to summarise entries in a risk register and output how many of each likelihood/impact combination occur (outputted then into a boston square). I have open and closed risks in the register and would like the DCOUNT not to count the closed items when I filter those out i.e. the Boston square only showing the open risks.

Hopefully I have attached the sheet...
The data entered on the "Test" tab is summarised in the "BS Sheet" tab using the DCOUNT formula. I would like the output on this tab to ignore, i.e. not count, cells when the status in column B of the "Test Tab" is "Closed".

Any assistance is greatly welcomed!

Amazing! Thank you for the rapid response. That's exactly what I needed.