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

"garyablett" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>
>
> --
> garyablett
> ------------------------------------------------------------------------
> garyablett's Profile:
> http://www.excelforum.com/member.php...o&userid=34145
> View this thread: http://www.excelforum.com/showthread...hreadid=539725
>

[Ragdyer]

Try this:

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

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"garyablett" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>
>
> --
> garyablett
> ------------------------------------------------------------------------
> garyablett's Profile:
http://www.excelforum.com/member.php...o&userid=34145
> View this thread: http://www.excelforum.com/showthread...hreadid=539725
>

[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"),--(D1:D100=1))

In article <[email protected]>,
garyablett <[email protected]>
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.

[garyablett]

thanks JE McGimpsey. that works great!