| 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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to sum cells corresponding to a specific reference?
Hi,
I think the answer for AG4499 is 10, try this =SUMIF(A:A,"AG4499",B:B) you could use a cell reference for the lookup value Mike "filpass" wrote: 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! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to sum cells corresponding to a specific reference?
Mike, you saved my day!!!
Thank you very much, it works perfectly. Enjoy a great day:) "Mike H" wrote: Hi, I think the answer for AG4499 is 10, try this =SUMIF(A:A,"AG4499",B:B) you could use a cell reference for the lookup value Mike "filpass" wrote: 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! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to sum cells corresponding to a specific reference?
Glad I could help
"filpass" wrote: Mike, you saved my day!!! Thank you very much, it works perfectly. Enjoy a great day:) "Mike H" wrote: Hi, I think the answer for AG4499 is 10, try this =SUMIF(A:A,"AG4499",B:B) you could use a cell reference for the lookup value Mike "filpass" wrote: 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! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to sum cells corresponding to a specific reference?
... sum up the values of column B
corresponding to each reference. To avoid typing each reference, and to help avoid typing errors, I would suggest a "Pivot Table." It's designed for this very purpose. :) - - - HTH Dana DeLouis filpass wrote: 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! |
| Reply |
| 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) | |||
Linear Mode
