Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is there a formula?
I have data in 2 columns, the first column contains location numbers, the 2nd
column contains values for those locations. Some locations have multiple values, so they are listed multiple times, (see below) Location # Value 878 $50,000 879 $22,449 882 $51,050 883 $20,420 884 $10,000 884 $50,000 885 $5,230 885 $20,920 886 $53,764 I need to see the total value for each location, so I need to add the multiple values for the locations that have them. Is there a formula I can use to do this and, if so, what is it? -- Thank you. debd |