ExcelBanter

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - sum (https://www.excelbanter.com/excel-worksheet-functions/54391-sum.html)

ceemo

sum

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

Anne Troy

sum

Try this, ceemo:
http://www.officearticles.com/excel/...ft_excel.h tm
************
Anne Troy
www.OfficeArticles.com

"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

Bob Phillips

sum

=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

RagDyer

sum

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

All times are GMT +1. The time now is 07:40 AM.