finding an entry from two criteria.

[garyablett]

Hi,

I am trying to add entries in a particular column on two criteria:
1.) that the enries i am looking for equal 1.
2.) that the entries i am looking for correspond to "The word customer"
in another column to the left.

The columns are not directly next to each other

Customer *1*
Stakeholder 1
Customer *1*
Supplier 1

The number in bold is the number i want.

Thanks

 

[Biff]

Hi!

It's not real clear what you want.

Do you want to count the number of times "customer" and "1" appear in the
same row?

Biff

 

[Ragdyer]

Try this:

=SUMPRODUCT((A1:A100="Customer")*(B1:B100=1))

 

[garyablett]

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.

 

[JE McGimpsey]

One way:

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

 

[garyablett]

thanks JE McGimpsey. that works great!