sum

[ceemo]

hi wondering if anyone can help



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

 

[Anne Troy]

Try this, ceemo:
http://www.officearticles.com/excel/sumif_using_multiple_criteria_in_microsoft_excel.htm
************
Anne Troy
www.OfficeArticles.com

 

[Bob Phillips]

=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)

 

[RagDyer]

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

RD

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

=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)