| Home |
| Search |
| Today's Posts |
|
|
|
#1
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
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
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
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
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 . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Month based data addition to worksheet | Excel Worksheet Functions | |||
| Selective addition based on criteria | Excel Discussion (Misc queries) | |||
| Column labels run right to left, not left to right | Excel Discussion (Misc queries) | |||
| Excel addition of column | New Users to Excel | |||
| column addition question | Excel Worksheet Functions | |||
Hybrid Mode
