Hi,

I have tried to figure this one out for myself using previous advice offered
but it has me baffled!!

I have 5 columns, Service, Sales, Maintenance, Fault, Non Fault. This
records accidents so if driver has a tick in the column then either Fault or
Non Fault will also contain a tick. I want to count which accidents are our
fault but because there are multiple driver columns I cant just do a COUNTIF
on the fault column, i need it for each driver type.

Lets simply use Service drivers for an example. I need to COUNTIF Service =
Yes AND Fault = Yes.

Service Fault Non Fault
x x
x x
x x
x x
x x

The Count here would need to equal 3 as there are 5 service accidents but
only 3 which are our fault.

I will then use this formula 3 times to provide a count for which of the
service acccidents were our fault, which of the sales accidents were our
fault and which of the maintenance accidents were our fault.

Thanks in advance.