ExcelBanter - Sumproduct

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Sumproduct (https://www.excelbanter.com/excel-worksheet-functions/184546-sumproduct.html)

Krandall

Sumproduct

I need a formula to add a column based on 2 criteria.

If A:A = A1 and B:B = B1 then sum C:C

Pete_UK

Sumproduct

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

On Apr 21, 4:40*pm, krandall
wrote:
I need a formula to add a column based on 2 criteria.

If A:A = A1 and B:B = B1 then sum C:C

All times are GMT +1. The time now is 11:42 PM.