| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need to combine and add data
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need to combine and add data
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need to combine and add data
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. -- smoked1 ------------------------------------------------------------------------ smoked1's Profile: http://www.excelforum.com/member.php...o&userid=30407 View this thread: http://www.excelforum.com/showthread...hreadid=500743 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
