Need to combine and add data

[smoked1]

I am a sysadmin but I don't have much experience working with excel. My problem is that I have three spreadsheets and they have the same column names but the number are not the same in four of the columns. I need to create one spreadsheet with all of the number added up where another column is the same on each spreadsheet. I am not sure if I am explaining this right so if you need more info please let me know. I am using excel 2003.

[TomHinkle]

I'm not sure I totally get what you're asking, BUT sounds like a pretty good
chance you are talking about the VLOOKUP function... look that up on help, it
will give a better description than I can in just text

"smoked1" wrote:

>
> I am a sysadmin but I don't have much experience working with excel. My
> problem is that I have three spreadsheets and they have the same column
> names but the number are not the same in four of the columns. I need to
> create one spreadsheet with all of the number added up where another
> column is the same on each spreadsheet. I am not sure if I am
> explaining this right so if you need more info please let me know. I am
> using excel 2003.
>
>
> --
> smoked1
> ------------------------------------------------------------------------
> smoked1's Profile: http://www.excelforum.com/member.php...o&userid=30407
> View this thread: http://www.excelforum.com/showthread...hreadid=500743
>
>

[smoked1]

I could be wrong but I don't think that is going to work for what I am doing. I need to add up different numbers in different workbooks based on weather or not another field matches. Like:
$var = a + a + a WHERE fieldname = fieldname from another workbook.