Formulas

Solved/Closed
Gmooney Posts 2 Registration date Friday February 14, 2014 Status Member Last seen February 14, 2014 - Feb 14, 2014 at 11:22 AM
Gmooney Posts 2 Registration date Friday February 14, 2014 Status Member Last seen February 14, 2014 - Feb 14, 2014 at 02:46 PM
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 responses

Kevin@Radstock Posts 42 Registration date Thursday January 31, 2013 Status Member Last seen April 26, 2014 9
Feb 14, 2014 at 01:31 PM
Try

=SUMIFS(C1:C20,A1:A20,1,B1:B20,"A")
0
Gmooney Posts 2 Registration date Friday February 14, 2014 Status Member Last seen February 14, 2014
Feb 14, 2014 at 02:46 PM
Fantastic answer. Very very smart....
0