Hi, I have data similar to the bottom. I want to add all the Zauri Inds,
Zyden Gentec, Zydus Wellness, Zylog Systems. How do i do that? I want to drag
a cell, so that addition happens automatically for the whole file. (I know
how to do addition in excel). The file is really really big. I want something
that automates this process based on the names to the left.


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

I assume that the names are in A Column and the corresponding values are in C
Column, if so, use this formula€¦

Paste the above formula in D1 cell

=SUMIF(A:A,A1,C:C)

Just copy the D1 cell and paste it for the remaining cells.

Change the cell reference in the above formula to your desired cells, if
required

If this post helps, Click Yes!

--------------------
(Ms-Exl-Learner)
--------------------



"Marc" wrote:

Hi, I have data similar to the bottom. I want to add all the Zauri Inds,
Zyden Gentec, Zydus Wellness, Zylog Systems. How do i do that? I want to drag
a cell, so that addition happens automatically for the whole file. (I know
how to do addition in excel). The file is really really big. I want something
that automates this process based on the names to the left.


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