While waiting for an update, I’m looking for a formula in a Numbers spreadsheet.

I have a column of different numbers - and want to check the cells that contain the number 4. This is column C.

In column D, there will also be different numbers and I want the ones that contain 999.

The result I’m looking for is a count of how many of those containing 4 also have 999 in the next column.

Column/Rows would be C3:C402 and D3:D402.

I figure “AND” will be involved but everything I see with formula examples only has co do with specific cells, not ranges. Or maybe a whole different approach is needed.