# Need Formula

#### jberwald

##### Board Regular
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.

### Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

#### DonkeyOte

##### MrExcel MVP
where D1 = first state listed, in E1:

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

#### jberwald

##### Board Regular

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

#### DonkeyOte

##### MrExcel MVP
are the entries in L numbers or text ?

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

#### MarkAndrews

##### Well-known Member
where D1 = first state listed, in E1:

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

Try this (adaptation if the above

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

#### jberwald

##### Board Regular
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

##### MrExcel MVP
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

##### Board Regular
hi,

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

Rajesh

Last edited:

Replies
3
Views
289
Replies
2
Views
406
Replies
1
Views
324
Replies
10
Views
720
Replies
14
Views
581

1,191,000
Messages
5,984,082
Members
439,872
Latest member
noaman79

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back