Hi
use sUMPRODUCT:
=SUMPRODUCT(--(B1:B100="outlook"),--(C1:C100="y"))

Also see:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

--
Regards
Frank Kabel
Frankfurt, Germany

"Danny J" schrieb im Newsbeitrag
...
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