Thanks Sheeloo,

I am very interested in learning, I tried to learn from the last array
formula I was given but found it very difficult due to limited help on the
Excel pages. If you know of any resources better at explaining array formula
I would very much appreciate that information.

I read through the SUMPRODUCT help but didn't think that it fit my use as it
adds the values of the cells whereas I want the toal number of cells
containing any value (in this case "ü" which gives a tick in Wingdings). I
will re read it though and see if I have missed something.

"Sheeloo" wrote:

You need to understand SUMPRODUCT and use it.
Start with learning ARRAY formula.

One of us can give you the formula if you do not want to learn... but it
will help you more in the long run

"Pyrite" wrote:

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.