Your sum range appears to only be returning "B2".

Try this:

=SUMIF(D5:D10,A2,B5:B10)

HTH,
Paul

It doesn't sound like you really want to do a SUM here though.  I think just
an IF statement will get the results you've described.

In F5, enter:

=IF(D5=$A$2,$B$2,"")

Copy this formula down through F10.

Is that what you're looking for?

HTH,
Elkar

=IF(A2="FRED",31,"Unknown")

I'm a bit puzzled about your requirements, but I'll see if this is what
you're looking to do....

In Col_A, you have a list of unique names
In Col_B, you have numeric values  associated with each name

Col_D has a list of names, possibly some names repeated.

In Col_F, you want to find the name from Col_D in the list in Col_A and
return the corresponding value from Col_B.

If that's true....try something like this.

Where D4: Fred
This formula will return the value associated with Fred
F4: =VLOOKUP(D4,$A$1:$B$10,2,0)
Copy that formula down as far as you need.

Am I on the right track here, or do you need something else?

Post back with more questions or clarifications
***********
Regards,
Ron

XL2002, WinXP

=IF(COUNTIF(D5:D10,A2),B2,"")