=SUMPRODUCT(--(A2:A100=A1),--(B2:B100=B1),C2:C100)

Is probably what Bob meant.

As Bob said, this doesn't have to be array entered, however, otherwise it
has all the behavior and restrictions of an array formula.

--
Regards,
Tom Ogilvy

"Bob Phillips" wrote in message
...
Here is a non-array way

=SUMPRODUCT(--(A2:A100=A1),--(B2:B100=B1,C2:C100)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Paul B" wrote in message
...
Gary, here is one way, =SUM(IF((A1:A5="m")*(B1:B5="x"),C1:C5)) This
is
an array formula use (ctrl+shift+enter)

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Gary Keramidas" wrote in message
...
how would you use these functions based on 2 criteria?

for example, if a1="m" and b1="x", how would you sum column c looking
for
just these 2 criteria in column a and b?

--


Gary