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

"MIK" wrote:

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?

Try this:

A10 = job #

=SUMIF(1:1,A10,2:2)

--
Biff
Microsoft Excel MVP


"MIK" wrote in message
...
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?

On Sat, 17 Jan 2009 13:32:00 -0800, MIK
wrote:

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?


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