Looking up text and couting value in same row

[jcleveland91]

I am interested in a formula that will look at the text in row A, find cells with the same text and add the values in the adjacent column together.

	A	B
1	Go Fetch	5
2	Drink Water	2
3	Go Fetch	7
4	Drink Water	3

<TBODY>
</TBODY>

Any help is greatly appreciated!

-J

 

[Marcelo Branco]

Hi and welcome to Mr Excel Forum

Use the SUMIF function. Take a look at the Help.

M.

 

[Peter_SSs]

Do you mean like this?
If not, more explanation please.

Formula copied down.

Excel Workbook
	A	B	C
1	Go Fetch	5	12
2	Drink Water	2	5
3	Go Fetch	7	12
4	Drink Water	3	5
SUMIF