I need a formula to add a column based on 2 criteria. If A:A = A1 and B:B = B1 then sum C:C
K krandall Apr 21, 2008 #1 I need a formula to add a column based on 2 criteria. If A:A = A1 and B:B = B1 then sum C:C
P Pete_UK Apr 21, 2008 #2 In versions of XL prior to 2007 you can't use full-column references with SUMPRODUCT, so try it like this: =SUMPRODUCT((A2:A1000=A1)*(B2:B1000=B1)*(C2:C1000)) I've assumed 1000 rows - adjust to suit. Hope this helps. Pete
In versions of XL prior to 2007 you can't use full-column references with SUMPRODUCT, so try it like this: =SUMPRODUCT((A2:A1000=A1)*(B2:B1000=B1)*(C2:C1000)) I've assumed 1000 rows - adjust to suit. Hope this helps. Pete