Hi All

I am looking for a formula to count how many entries there are on a spreadsheet, that DO NOT meet a criteria, for example, I want it to count everything that dos NOT have "Closed" in the column F

Hoping that you may be able to provide me with an example that will save me having to manually count about 1.4k entries!

Thanks
Martin