One way:

=SUMPRODUCT(--(A1:A100="customer"),--(D1:D100=1))

In article ,
garyablett
wrote:

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.