|
| 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
November 11th, 2009, 05:16 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
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 
|
|
#2
November 11th, 2009, 05:21 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
|
|
#3
November 11th, 2009, 05:22 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
|
|
#4
November 11th, 2009, 05:22 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 .
|
|
#5
November 11th, 2009, 05:56 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 .
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
