Suppose I have rows 1 to 10 and columns A to E. I want to add up all the
values in Columns A but only when the value of column B = criteriaB and value
of column C = criteriaC. How do I do this?

When you have move than 1 criterias; use SUMPRODUCT(). With criteria1 in cell
F1 and criteria2 in cell F2; try the below formula

=SUMPRODUCT(--($B$1:$B$100=F1),--($C$1:$C$100=F2),$A$1:$A$100)

If this post helps click Yes
---------------
Jacob Skaria


"Boying Opaw" wrote:

Suppose I have rows 1 to 10 and columns A to E. I want to add up all the
values in Columns A but only when the value of column B = criteriaB and value
of column C = criteriaC. How do I do this?

On Thu, 8 Oct 2009 19:02:01 -0700, Boying Opaw
wrote:

Suppose I have rows 1 to 10 and columns A to E. I want to add up all the
values in Columns A but only when the value of column B = criteriaB and value
of column C = criteriaC. How do I do this?


Try this formula:

=SUMPRODUCT((A1:A10)*(B1:B10=criteriaB)*(C1:C10=cr iteriaC))

Hope this helps / Lars-Åke

If you're using Excel 2007...

Use cells to hold the criteria.

G1 = criteriaB
H1 = criteriaC

=SUMIFS(A1:A10,B1:B10,G1,C1:C10,H1)

--
Biff
Microsoft Excel MVP


"Boying Opaw" wrote in message
...
Suppose I have rows 1 to 10 and columns A to E. I want to add up all the
values in Columns A but only when the value of column B = criteriaB and
value
of column C = criteriaC. How do I do this?