# Formula required to add cells

#### DONHODGE

##### New Member
Require formula to add across cells. Example I wish to countif in K:K for range Hodge then relate this to another range in L:L for range TA. The rersult should be to look up K:K for Hodge then on same row look for TA then get a number. Is there such a formula

### Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

##### MrExcel MVP
hi - welcome to te board!

I think I know what you mean, but rather than speculate, why don;t you post back with a fuller description of what you're trying to do. include details of your data, where it is on the sheet etc. give an example, including the expected outcome.

#### DONHODGE

##### New Member
I am preparing a record sheet to record the activities of people I supervise. In column A for example I enter a persons name e.g. HODGE. I then in column B ( same row) I enter a code eg TA for the activity. To obtain what the persons performance is I need to know what activity HODGE has done which I record on another sheet. The formula I seek should collate HODGE in Column K with the desired activity code in Column L which will give me a number on the record sheet for HODGE for that activity.

#### Zack Barresse

##### MrExcel MVP
WTR04.xls
DEFG
17J3
18A3
19A65
20B45
21B12
22B32
23C78
24C98
25C19
26A68
test

you should be able to change out D26 to whatever you want. if you don't want to change the cell contents, maybe a vlookup would work for you as a more static solution, maybe?

#### DONHODGE

##### New Member
Tried it does not add up value. Maybe this will help?

(ROW) A B C
Name Code Total
HODGE TA TO GET THIS FIGURE LOOK AT ROW
(A) FOR HODGE THEN ROW (B) FOR TA.
ROW (C) SHOULD HAVE TOTAL FOR TA FOR
HODGE.

At the end I require the total for HODGE in relation to TA. When Hodge is entered in Row A then the code TA or something similar is to be always entered in ROW B. Total HODGE + TA is number required in Row C.

#### just_jon

##### Legend
Have you looked into SUMPRODUCT? Try a search on this board; if not helped, post back.

Replies
7
Views
88
Replies
4
Views
135
Replies
0
Views
122
Replies
5
Views
221
Replies
0
Views
90

### Forum statistics

1,186,160
Messages
5,956,272
Members
438,245
Latest member
bhavdip_mangukiya

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