Searching for values in multiple cells, and reporting info in corresponding cells.

[DANNYB667]

Ok here goes....I have a spreadsheet with multiple data charts. I need a formula (for column J) which searches through column C for a specific text (which could occur in any or all of the cells), and when returns true, adds the numbers up in the correlating cell in colum d.

Example C D J
a 1 a 6
b 3 b 7
c 4 c 4
b 4 d 44
a 2
a 3
d 44

here is what i came up for a single cell =IF(C1="a",D1,0) but i need it to search for all of the "a" in column C, and add all the amounts in column D. HELP!!!!

 

[DANNYB667]

Sorry that table didnt work.

 

[PlusBob]

I believe that I have a similar request.


I have a column with names, a column with hours they worked. There's a list of names under the data, and next to the list I want it the result to be the added hours for each name. Can you help?

[TABLE="width: 500"]
<tbody>[TR]
[TD]NAME[/TD]
[TD]HOURS[/TD]
[TD][/TD]
[TD]List[/TD]
[TD]Total hours [this where I want the formula][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]John[/TD]
[TD]1[/TD]
[TD][/TD]
[TD]Bob[/TD]
[TD]2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Bob[/TD]
[TD]2[/TD]
[TD][/TD]
[TD]John[/TD]
[TD]5[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]John[/TD]
[TD]1[/TD]
[TD][/TD]
[TD]Mark[/TD]
[TD]2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]John[/TD]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Mark[/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[PlusBob]

Here try this one:http://www.mrexcel.com/forum/excel-...n-summing-value-another-cell.html#post4659071