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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help for an excel newbie
gingertips,
One function to use is =TEXT(A2, "mmm") or TEXT(A1, "mmm-yy") This can create an additional column (say C:C), which will extract the month portion. Use the second version if you also need to distinguish between years. This function is for next to the data and will be used by the summation functions. For summation, assuming your months are in A:A use =SUMIF(Sheet1!C:C, A2, Sheet1!B:B) If you have them in different workbooks use clicking for the arguments while editing the formula, this will properly enter the full workbook/worksheet name in lieu of Sheet1 in the suggested formula. HTH Kostis Vezerides |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help for an excel newbie
Brilliant - thankyou! Ive updated it as follows to make sure if a column is blank that it doesnt return Jan as the month: =IF(A10="","",TEXT(A10,"mmm")) Need to get myself more reading material, but thanks for your help! ;) -- gingertips ------------------------------------------------------------------------ gingertips's Profile: http://www.excelforum.com/member.php...o&userid=30974 View this thread: http://www.excelforum.com/showthread...hreadid=506416 |
Reply |
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) |