On Jan 12, 12:54*pm, Julie wrote:
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.

You want =SUMIF(
Check the help for constructing your ranges.
Pierre