If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Additions
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 |
#2
|
|||
|
|||
Additions
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 |
Thread Tools | |
Display Modes | |
|
|