Formula help

[brockedp]

Hi,
I am new to formulas on excel. I need help making a formula which will find names that are located on a spreadsheet and the numbers associated with them in the cell next to them. Once they find the name, it will sum up the numbers associated wit them. This formula will be used for conducting hours spent working on a job by an individual. If the formula could be explains too, i would really appreciate it. Thank you for the help.

 

[shyy]

Hi and welcome to the board!

You should look into the SUMIF, SUMPRODUCT function since you are dealing with numbers.

Post up a sample of your data.

Excel 2010
	A	B	C	D	E
23	John	12		Smith	21
24	Smith	21		John	138
25	Joe	32
26	Doe	321
27	John	3
28	John	123
29	Joe	12
30	Joe	3122
Sheet3

Cell Formulas
Range	Formula
E23	=SUMIF($A$23:$A$30,$D23,$B$23:$B$30)
E24	=SUMIF($A$23:$A$30,$D24,$B$23:$B$30)