With a minor correction to Bob's typing:
=SUMPRODUCT(--(A2:A200="place 1"),==(C2:C200="B"),D2:D200)
becomes
=SUMPRODUCT(--(A2:A200="place 1"),--(C2:C200="B"),D2:D200)

You should have gotten a "good" answer.

If 0 isn't correct, then I'd check A2:A200 to see if "place 1" is really in
those cells (maybe extra spaces--leading, trailing, embedded.

Same kind of thing with column C.

And make sure d2:D200 are numbers--not text masquerading as numbers.

if you type:
=count(d2:D200)
do you get 199
(assuming no empty cells)

macquarl wrote:

I attempted the SUMPRODUCT example and got "0" for my total when I
should have gotten something. I am not sure if it's the right formula
to use though, I need to add the points together for the bundle of
locations and ranks. Isn't the SUMPRODUCT one used to multiply the
different array elements together?

--
macquarl
------------------------------------------------------------------------
macquarl's Profile: http://www.excelforum.com/member.php...o&userid=26388
View this thread: http://www.excelforum.com/showthread...hreadid=498115

--

Dave Peterson