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.