| Home |
| Search |
| Today's Posts |
|
#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. |
| 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) | |||
![Ashish Mathur[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
