Formula Madness
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
|