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!
Bookmarks