| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to sum cells corresponding to a specific reference?
Dear all,
I have column A with different references (e.g. LC43029, AG4499, B213344) and column B with how many of each reference I have in my stocks. Now, I have many different stocks and would like to sum up the values of column B corresponding to each reference. For instance: AG4499 3 LC43029 1 AG44991 2 AG4499 2 AG4499 5 LC43029 4 Value for AG4499 = 3+2+2+5 = 12 Value for LC43029 = 1+4 = 5 How can I do that? A thousand of thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Getting specific data into specific cells? | Excel Discussion (Misc queries) | |||
| Count all but a specific reference cell (countif ?) + | Excel Worksheet Functions | |||
| Formula so if reference is selected, a specific value is returned. | Excel Worksheet Functions | |||
| Formula so if reference is selected, a specific value is returned | Excel Discussion (Misc queries) | |||
| Automate selection of specific reference cells | Excel Discussion (Misc queries) | |||
Threaded Mode
