Sum of data with two criteria

  • Thread starter Thread starter Simon Zarus
  • Start date Start date
S

Simon Zarus

Hi there, i have a (simple!?) problem with the following..

In my sheet, i have 3 columns:

column A, containing a order-number
column B, containing a quota
column C, containing a week-number


Now what needs to bee counted, is the SUM of the quota (column B)
occurences from a specific order, AND a specific week!

Problem is, the rows can contain multiple occurences of an
ordernumber...


I'm feeling quitte stupid, can anyone help me please? :confused:
 
Hi
try
=SUMPRODUCT((A1:A1000=order_number)*(C1:C1000=week_number),(B1:B1000))

Frank
 
One way:

Assume your order-number is in D1 and your week number is in cell D2.

=SUMPRODUCT(--(A1:A1000=D1),--(C1:C1000=D2),B1:B1000)
 
Back
Top