VLOOKUP and SUM

[Emma87]

I am looking for a formula to look up the same name then add up the total numbers next to it. It always brings back just one instance when I write my formula.

 

[Marcelo Branco]

Welcome to Mr Excel forum

Try SUMIF
Take a look at
http://www.contextures.com/xlFunctions01.html#SumIf

Hope this helps

M.

 

[Emma87]

so in the example on the page you posted it just shows pen however if I wanted to give the total of all the items separately how would that look?

 

[Marcelo Branco]

Create a list of items and copy the formula down

Something like this

	A​	B​	C​	D​	E​
1​	Item​	Qty​		Criteria​	Result​
2​	Pen​	5​		Pen​	37​
3​	Pencil​	9​		Pencil​	19​
4​	Binder​	9​		Binder​	27​
5​	Pen​	6​
6​	Pen​	15​
7​	Binder​	12​
8​	Pencil​	10​
9​	Binder​	6​
10​	Pen​	11​

<tbody>
</tbody>

Formula in E2 copied down
=SUMIF(A$2:A$10,D2,B$2:B$10)

M.