Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help for an excel newbie
Hi all, As a newbie, im trying to learn as fast as I can about fucntions in excel. hwoever I am struggling with one at the moment & I dont really know what function I should use to achieve my end goal. I have 3 workbooks - sheet1, sheet2 & sheet 3. each workbook contains 2 columns - Date and Amount. On a 4th workbook, I would like to total ALL amounts for a given month - so a table with Jan, Feb, Mar etc. This total will check the other 3 workbooks and add up all entries that relate to that month. What should I use? The second part, I would like to calculate a daily/profit or loss, so want to be able to add together all entries relating to say 5th January and get a total. Again, what function should I be using? Thanks in anticipation! -- gingertips ------------------------------------------------------------------------ gingertips's Profile: http://www.excelforum.com/member.php...o&userid=30974 View this thread: http://www.excelforum.com/showthread...hreadid=506416 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
convert pocket excel back to standard excel | Excel Discussion (Misc queries) | |||
Please help an Excel Newbie! | New Users to Excel | |||
"Group" function very slow with Excel 2003 :( ... While very quick with Excel2000 :O) | Excel Discussion (Misc queries) | |||
Excel error - Startup (and Acrobat PDFMaker) | Setting up and Configuration of Excel | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) |