Thanks again, I figured out what the error is I am hoping you can help me
with this.

Here is the working formula

=SUMPRODUCT(((YEAR(A8:A12)=2009))*(B8:B12="D03KHLL "),L8:L12)

If you noticed I shortened the rows to "12" and thats when the formula
worked the problem is rows 12 - 23 are blank thus leaving a #VALUE in those
blank cells that the formula is trying to work against. because this is a
template for 100 + other sheets some times rows 13 - 23 will be populated and
other times it wont be.

How can I get the formula to ignore the #VALUE in the blank cells

I should mention that these blank cells are being populated by this formula

=IF(ISERROR(INDEX(ALL,SMALL(IF(customername=B3,ROW (customername)),ROW(RawData!5:5)),7)),"",(INDEX(AL L,SMALL(IF(customername=B3,ROW(customername)),ROW( RawData!5:5)),7)))






--
Nelson


"David Biddulph" wrote:

Perhaps you intended
=sumproduct((B8:B23="D03KHLL")*(year(A8:A23)=2008) ,L8:L23) ?
--
David Biddulph

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