Need Formula

[jberwald]

I have a worksheet that I do every quarter for corporate that could really use some formulas.

Column D contains all the counties in a state (in alpha order).

Column K contains only the counties (in alpha order) in that state that we have sold to(counties we have not sold to are missing from the list).

Column L contains the amount sold to these counties

I need a formula to match up the county in Column D with the same county in Column K (if it is there) and then transfer the info in Column L to Column E.

If this is possible it would save me alot of time each quarter!
Thanks.

 

[DonkeyOte]

where D1 = first state listed, in E1:

=SUMIF(K:K,D1,L:L)

 

[jberwald]

That didn't work - returned all "0's"

 

[DonkeyOte]

are the entries in L numbers or text ?

what happens if you enter = SUM(L:L) into any cell -- do you get 0 ?

 

[MarkAndrews]

where D1 = first state listed, in E1:

=SUMIF(K:K,D1,L:L)

Try this (adaptation if the above

Copied down your sheet

=SUMIF($K:$K,$D1,$L:$L)

 

[jberwald]

Columns D and Column K are the counties - not the same exact list though - Column K is missing some counties contained in Column D (ex. Column D has: D1:Alpha, D2:Betty and D3:Charlie; Column K only has K1:Charlie)

Column L is a number

I need the number in L1 - for Charlie County to transfer to D3 - for Charlie County

 

[DonkeyOte]

if the SUMIF's are all returning 0 then either the counties in D do not match the format in K or the values in L are not numeric.

if you're adamant that L is numeric (ie SUM(L:L) does NOT return 0) then you need to check the county... find a county that as far as you're concerned DOES exist in K and do the following

=MATCH(Dx,K:K,0)

where x = row containing the county you believe exists in K -- what is the result ?

 

[ysrmkp]

hi,

could u please send the sample file to ysrmkp at gmail dot com, so that i can work on it.

Rajesh