Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to sum all values of a variable that's repeated multiple times
I have a column where there are several variable, repeated many times.
On the right column the values of the variable ate given. I want to add up all the values of each unique variable and get a table that has all unique variables in one column and their corresponding summed up values on the next cell. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to sum all values of a variable that's repeated multiple times
Hi,
Just highlight the range and create a pivot table. This will give you exactly what you want. -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "NC" wrote in message ... I have a column where there are several variable, repeated many times. On the right column the values of the variable ate given. I want to add up all the values of each unique variable and get a table that has all unique variables in one column and their corresponding summed up values on the next cell. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to sum all values of a variable that's repeated multiple times
Sub sumifunique()
With Range("a1:a" & Cells(Rows.Count, "a").End(xlUp).Row) .AdvancedFilter Action:=xlFilterCopy, _ CopyToRange:=Range("E1"), Unique:=True Range("F1:f" & Cells(Rows.Count, "e").End(xlUp).Row) _ .Formula = "=sumif(a:a,e1,b:b)" End With End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "NC" wrote in message ... I have a column where there are several variable, repeated many times. On the right column the values of the variable ate given. I want to add up all the values of each unique variable and get a table that has all unique variables in one column and their corresponding summed up values on the next cell. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Max no. of times a text repeated | Excel Discussion (Misc queries) | |||
Inserting Data Repeated Times | Excel Discussion (Misc queries) | |||
Find multiple repeated values in a Pivot Table | Excel Worksheet Functions | |||
Looking up values,problem: they occure multiple times | Excel Discussion (Misc queries) | |||
Count No. of times Dates are repeated | Excel Discussion (Misc queries) |