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?

NAME	HOURS		List	Total hours [this where I want the formula]
John	1		Bob	2
Bob	2		John	5
John	1		Mark	2
John	3
Mark	2

<tbody>
</tbody>

 

[PlusBob]

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