excel slow on large number of entries with calculations

Hi Experts this is an issue that refuses to go away, i noticed that with an excel sheet with large number of rows, usually more than 10K rows, along with a simple calculation like countif, causes ex...