Formulas [Solved/Closed]

Report
Posts
2
Registration date
Friday February 14, 2014
Status
Member
Last seen
February 14, 2014
-
Posts
2
Registration date
Friday February 14, 2014
Status
Member
Last seen
February 14, 2014
-
sum a column if two other columns contain a specific text each
so sum (if (A1:A20=1 and B1:B20 = "A", C1:c20)

2 replies

Posts
42
Registration date
Thursday January 31, 2013
Status
Member
Last seen
April 26, 2014
9
Try

=SUMIFS(C1:C20,A1:A20,1,B1:B20,"A")
Posts
2
Registration date
Friday February 14, 2014
Status
Member
Last seen
February 14, 2014

Fantastic answer. Very very smart....