Thread: Formula Madness
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
IoHeFy IoHeFy is offline
external usenet poster
 
Posts: 12
Default 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