Sorry,

I should have been more clear with what i want.

in column A there are three types of people: customer, stakeholder and
supplier.

In column D they are all ranked 1-5

what i want to do is to count the* customers* that are ranked *1*. i
want to do this for approximately 100 entries.

Any help would be great.


--
garyablett
------------------------------------------------------------------------
garyablett's Profile: http://www.excelforum.com/member.php...o&userid=34145
View this thread: http://www.excelforum.com/showthread...hreadid=539725