Nelson

I have undertood that yuo are looking or to sum the numbers you have in
column L (range L8:l23) whem both conditions are true i.é. b8:;b23 has
D03khll and the year of the dates on column A is equal to 2008. so the
sumproduct will work.

The * will multiply 1 (true) whem the first condition is true by 1 (true)
when the second conditon is true. if one of both are false it will 0 (zero).

Try this (I notice that was a "," before 2008 and the previous)
=sumproduct--((B8:B23="D03KHLL")*(year(A8:A23)=2008),(L8:L23))

hth
--
pleae click yes if it was helpfull
regards from Brazil
Marcelo



"Nelson" escreveu:

Thanks but it didnt work, the one thing that I am confused about is the *
between the arrays.

I am not looking to multiply

Basically if part number X matchs in Rows 8- 23 with D03KHLL and of those
rows match only the year 2009 then add the associated figues together from
Column L8:L23

So if 2 out of the 4 rows match the criteria of part number D03khll and year
2009 add the cells in L8:L23 that match those rows

hope that clears it up.

--
Nelson


"Marcelo" wrote:

Hello Nelson

try
=sumproduct--((B8:B23="D03KHLL")*(year(A8:A23)=2008),(L8:L23))

hth
--
pleae click yes if it was helpfull
regards from Brazil
Marcelo



"Nelson" escreveu:

Here is what I have

=SUMIFS((L8:L23, B8:B23),"=D03KHLL",year(A8:A23),=2008))


L8:L23 are the amounts

Criteria 1
B8:B23 (which are the part numbers )
="=D05555" a part

Criteria 2
and year(A8:A23) the corresponding part number from criteria 1 is 2009

give me the result from adding those matching costs from L8:L23

here is the kicker, I can get this to work if I take the year criteria out,
the result is that I get all costs associated to that part number, but once I
throw in the need to break out the cost per differing year I get nothing.

Any suggestions



--
Nelson