need excel formula

[mhawkins]

i am trying to create a formula which will allow me to check my expenses by months, for e.g. if i have 7 expense sheets 4 for feb and 3 for march, i need a formula that will recognise the different dates feb or march in a single cell and give me the total of all the expense sheets for the month i request. i am going to need to do this for the year eventually. any ideas have been trying for a week and it is doing my head in

thanks

 

[xlbo]

No way are you going to get a formula to do this - you may get a UDF that'll work but may I suggest that if you can, change the design of the workbook so that you only have 1 expenses sheet per month - that would make things MUCH easier

Rgds
Geoff
"Some cause happiness wherever they go; others whenever they go."
-Oscar Wilde

 

[mhawkins]

so if i grouped all the info into 1 sheet per month, could i then have a formula in a seperate workbook to filter out the required months?

 

[xlbo]

Depends on how your data is setup and what you want to return but by having it on multiple sheets and not necessarily the same number of multiple sheets, you are making the request impossible without code

Rgds
Geoff
"Some cause happiness wherever they go; others whenever they go."
-Oscar Wilde

 

[KenWright]

Why would you need a separate workbook. You could put all the data in a single worksheet and as long as you have a field such as date, you can either use Autofilter. Advanced Filter, or Pivot Tables to interrogate the data.

Each of these methods will allow you filter down to a specific month and focus on that if you wish.

Regards
Ken................