View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Marc Marc is offline
external usenet poster
 
Posts: 70
Default 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