Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi!
Hope someone can help, I'm sure it's pretty easy to sort out. I have an expenses spreadsheet. I have to make monthly totals from a continuous spreadsheet. For example, on my worksheet 'Expenses', coloumn A is a date in 01/01/07 format, and coloumn B is a total spent on the corresponding date. On the next worksheet 'Monthly Totals' I have seperate boxes for each month, Jan - Dec, and in each I obviously need to put a formula that will basically create a total for each relevant month based on the data from the expenses worksheet. So for January I'd be looking for a formula that added up any items in coloumn B that fall within January. Does that make sense? Very grateful for any help with this. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Reusing formula | Excel Discussion (Misc queries) | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |