Sumif vs Text?

[Guest]

Excel2003 ... Sample

Cell A2 ... Fred
Cell B2 ... 31
Range D510 ... Various Names (people ... including "Fred")
Col F ... Formula ... =sumif(D510,A2,B2) ... Keeps returning "0"

Where I find "Fred" in Col D ... I want to place the "31" in Col F adjacent
to Fred ... I am sure it is simple ... but I have tried all kinds of
girations with the A2 .. AND I am just not getting it (Friday the 13th?) ...
... Thanks ... Kha

 

[PCLIVE]

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

Try this:

=SUMIF(D510,A2,B5:B10)

HTH,
Paul

 

[Guest]

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

 

[Guest]

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

 

[Guest]

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

 

[Guest]

=IF(COUNTIF(D510,A2),B2,"")

 

[Guest]

Yes ... I found my way there ... Thanks ... Kha

=IF(COUNTIF(D510,A2),B2,"")