Find the each number used in row #1 and sum value of each number

  • Thread starter Thread starter MIK
  • Start date Start date
M

MIK

Hi,

I have job # used in row 1 and their value in row 2. I want to find the
numbers used in row 1 and then sum value of each job #. Can someone help me
on this?
 
Hi,

try this

=SUMPRODUCT((A1:M1=A3)*(A2:M2))

Where A3 is the job number you're looking for

Mike
 
Hi,

I have job # used in row 1 and their value in row 2. I want to find the
numbers used in row 1 and then sum value of each job #. Can someone help me
on this?
Click to expand...


If there are nothing but job # in row 1 and nothing but the
corresponding values in row 2, you may try the following formulas:

In cell A3:
=SMALL(1:1,1)

In cell A4:
=SUMPRODUCT((A3=1:1)*(2:2))

In cell B3:
=IF(SUM($A4:A4)>=SUM(2:2),"",SMALL(1:1,2+COUNTA(1:1)-RANK(A3,1:1)))

In cell B4:
=IF(B3="","",SUMPRODUCT((B3=1:1)*(2:2)))

Copy cells B3 and B4 to the right as far as needed

Hope this helps / Lars-Åke
 
Back
Top