Hi folks,

I am stuck and any help would be appreciated. I want to set a condition
which counts the number of people who have come on an outlook course. I
created the following equation:- =countif(A1:E20,and(b2="outlook",c2="y")).
A1:A20 being the worksheet, column A being the delegate name, column B the
course name and column c being did the delegate attend, y/n?

Looking at it I realise it must be wrong but cannot think of what the answer
should be.

Help!

Thanks,

Danny