Try SUMIF()

=SUMIF(A:A,"Zylog Systems",B:B)

If this post helps click Yes
---------------
Jacob Skaria


"Marc" wrote:

How can I add the column on the right based on entries to the left? I want to
add up all Zuari Inds., Zydec Gentech, Zydus Wellness, Zylog Systems.

Zuari Inds. 0
Zuari Inds. 0
Zuari Inds. 0.04
Zuari Inds. 0
Zuari Inds. 0
Zuari Inds. 0
Zuari Inds. 0
Zuari Inds. 0.01
Zuari Inds. 0
Zyden Gentec 2.09
Zyden Gentec 9.43
Zydus Wellness 61.42
Zydus Wellness 5.46
Zydus Wellness 61.42
Zydus Wellness 0.01
Zydus Wellness 0
Zydus Wellness 0.14
Zylog Systems 0.15
Zylog Systems 0.15
Zylog Systems 0.27
Zylog Systems 0.67
Zylog Systems 1.09