And turn the next to last parenthesis the *other* way!<g
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Bob Phillips" wrote in message
...
=SUMPRODUCT(--(A2:A200="criteria1"),--(B2:B200="criteria2"(,C2:C200)

you cannot use complete columns (A:A) with SUMPRODUCT

--

HTH

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


"ceemo" wrote in
message ...

hi wondering if anyone can help



Im after a formula that will sum column C where column A meets a
certain criteria as well as where column B meets a certain criteria


--
ceemo
------------------------------------------------------------------------
ceemo's Profile:
http://www.excelforum.com/member.php...o&userid=10650
View this thread:
http://www.excelforum.com/showthread...hreadid=483250