Addition based on left column
 

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

Addition based on left column
 

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

Addition based on left column
 

Try this...

=SUMIF(A:A,"Zuari Inds.",B:B)

Better to use cells to hold the criteria...

D1 = Zuari Inds.

=SUMIF(A:A,D1,B:B)

--
Biff
Microsoft Excel MVP


"Marc" wrote in message
...
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

Addition based on left column
 

Thank You. But how do I get this in a new excel tab? I only want to see
something like this:

Zauri Inds (=sum from earlier sheet)
Zyden Gentech (=sum from earlier sheet)
Zydus Wellnes (=sum from earlier sheet)

Your formula works, but there are repeats. I only want one entry in a new
sheet.

"T. Valko" wrote:

Try this...

=SUMIF(A:A,"Zuari Inds.",B:B)

Better to use cells to hold the criteria...

D1 = Zuari Inds.

=SUMIF(A:A,D1,B:B)

--
Biff
Microsoft Excel MVP


"Marc" wrote in message
...
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



.

Addition based on left column
 

On a new tab, list the unique names then use the formula referring back to
the other sheet.

You can use the advanced filter to get the unique names. See this:

http://contextures.com/xladvfilter01.html#FilterUR

--
Biff
Microsoft Excel MVP


"Marc" wrote in message
...
Thank You. But how do I get this in a new excel tab? I only want to see
something like this:

Zauri Inds (=sum from earlier sheet)
Zyden Gentech (=sum from earlier sheet)
Zydus Wellnes (=sum from earlier sheet)

Your formula works, but there are repeats. I only want one entry in a new
sheet.

"T. Valko" wrote:

Try this...

=SUMIF(A:A,"Zuari Inds.",B:B)

Better to use cells to hold the criteria...

D1 = Zuari Inds.

=SUMIF(A:A,D1,B:B)

--
Biff
Microsoft Excel MVP


"Marc" wrote in message
...
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



.