Grouping Data and Summing numbers by row

Ok, I'm not very tech savvy but know this should be doable in Excel.

To simplify say I have 5 rows and 3 columns below:

A | 3 | 5
A | 2 | 7
B | 8 | 2
B | 1 | 3
B | 3 | 9

I want to group the rows by the first column at the same time sum columns 2 and 3 so the above would go to ...

A | 5 | 12
B | 12 | 14

How can I do this ... do I need a macro?
(BTW, the first column is a domain name, ex. yahoo.com)

Thanks in advance

Originally Posted by DonkeyOte

You could use a Pivot Table or you could apply a Subtotal (see Data Tab -> Subtotal) - at each change in Column A apply SUM to Columns B & C then use the Group Buttons (1,2 etc) to see the appropriate level.
Note: both options require your data table has a header row.

Thanks it worked

I need to sum a time series data for a number of countries while considering the following
- each observation has a start date in cell B
- Each observation has an end date in Cell C
- data start from 1990 in cell D to 2009 in cell W


so what is the formula I can use if I want to sum for example the data for country x using start date in B and end date in C (from the range of cells from D to W)

@gigi2910, post your own thread. Your questions are off topic in this thread.

bluegreen, can you post a dummy file?