sum

C

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
 
B

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

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 !
---------------------------------------------------------------------------

Bob Phillips said:
=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)
Click to expand...
 
Top