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.