Solved

# Pretty simple Excel formula.  Add values from two columns.

Posted on 2011-04-22
225 Views
Hello Excel Experts,

I have attached an example.  I have data in two columns.  For instance:

``````1000              1
1000              3
1001              6
1001              3
1002              9
1003              5
1003              3
``````

I would like to add up all the values for 1000.  As well as 1001, 1002, 1003 (and so forth).

The results for the above would look like:

``````1000              4
1001              9
1002              9
1003              8
``````

If someone could help me with the proper formula so that I could add the data from column B together if Column A is the same value.  If you could post it in my example, then that would be especially helpful.  Thanks!

Example.xls
0
Question by:activematx

LVL 30

Expert Comment

Why not use Pivot Tables?

Sid
0

LVL 30

Assisted Solution

Here is an example

Sid
Copy-of-Example.xls
0

LVL 9

Author Comment

Thanks SiddarthRout.

How do I make it do what you did there?
0

LVL 30

Expert Comment

Here is a small tutorial that I wrote few years ago.

Hope this helps?

Sid
0

LVL 41

Accepted Solution

Another alternative, using sumif...

Put this in column B and drag down:

See attached,

Enjoy!

Dave
example-r1.xls
0

LVL 9

Author Closing Comment

Thanks
0

## Featured Post

### Suggested Solutions

Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
Using Word 2013, I was experiencing some incredible lag when typing.  Here's what worked for me....
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.