What I need is to sum column g, if column a = "T01", and column b = P43
J Jim Thomlinson Nov 17, 2006 #2 You want to use sumproduct... =sumproduct(--(A1:A1000="T01"), --(B1:B1000=P43), (G1:G1000)) Check out this link for more info on sumproduct... http://www.xldynamic.com/source/xld.SUMPRODUCT.html
You want to use sumproduct... =sumproduct(--(A1:A1000="T01"), --(B1:B1000=P43), (G1:G1000)) Check out this link for more info on sumproduct... http://www.xldynamic.com/source/xld.SUMPRODUCT.html
