Ashish,

I don't want to use a pivot table because I was told I would have to
recreate the pivot table every time I wanted to update the spreadsheet. I
will be using this formula every week on new data and want to write something
that I can simply refresh.

Julie

"Ashish Mathur" wrote:

Hi,

You may create a pivot table. Drag Name to the row area and 401k, FICA to
the data area. The pivot will auto summarise your data

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Julie" wrote in message
...
I have a worksheet that has multiple rows that have the same name. For
example.

I have a worksheet that looks like this
Name 401k FICA
Julie 100 200
Patrick 200 400
Sam 50 100
Julie 100 200
Julie 100 200
Patrick 200 400

I am trying to figure out how I can have excel look at the worksheet and
find all entries labed Patrick and return the columns already summed.
Similar
to a vlookup but able to know that if I want the 401k column it should
return
400 for Patrick after finding his name twice and summing that column. If
I
wanted the FICA column it would return 800 for that column.

I want to create a new tab where I can write a formula and aggregate the
data the way we want to view it for analysis. Is this possible?

I am using Excel 2003.