Need to combine and add data

S

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.
 
T

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
 
S

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.
 
Top