You should use COUNTIF when you have just one ... In the above image, an Excel sheet breaks down the payroll for two separate ...