Try this:

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

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"garyablett" wrote
in message ...

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