ExcelBanter - LOOK UP AND SUM

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - LOOK UP AND SUM (https://www.excelbanter.com/excel-worksheet-functions/242137-look-up-sum.html)

LOOK UP AND SUM

I am trying to look through a list on names in one column and values in the
column next.
If I have a name that repeats I want to add all the corresponding values
from the column next.
EG.
ABC 11
ZXY 8
GUK 22
ABC 3
ABC 8

ABC Total = 22

Any ideas?

ryguy7272

LOOK UP AND SUM

=SUMPRODUCT(--(A1:A5="ABC"),--(B1:B5))
=SUMPRODUCT((A1:A5="ABC")*(B1:B5))

HTH,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.

"AC" wrote:

I am trying to look through a list on names in one column and values in the
column next.
If I have a name that repeats I want to add all the corresponding values
from the column next.
EG.
ABC 11
ZXY 8
GUK 22
ABC 3
ABC 8

ABC Total = 22

Any ideas?

Teethless mama

LOOK UP AND SUM

Take a look SUMIF function in help menu

"AC" wrote:

I am trying to look through a list on names in one column and values in the
column next.
If I have a name that repeats I want to add all the corresponding values
from the column next.
EG.
ABC 11
ZXY 8
GUK 22
ABC 3
ABC 8

ABC Total = 22

Any ideas?

All times are GMT +1. The time now is 09:55 AM.