Addition based on left column

  • Thread starter Thread starter Marc
  • Start date Start date
M

Marc

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
 
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)
 
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.
 
Back
Top