How To Sum Rows

[Boying Opaw]

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?

 

[Jacob Skaria]

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

 

[Lars-Åke Aspelin]

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

Hope this helps / Lars-Åke

 

[T. Valko]

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)