Calculations depending on the date aaaaaah!

  • Thread starter Thread starter KrisB_bacon
  • Start date Start date
K

KrisB_bacon

Hi

I've got a spreadsheet managing a School Geography Department'
accounts. I've got a table of income and expenses and their totals.

The table is connected to another table which has figures abou
fieldtrips (in years 2002 to 2008). Therefore, I need the formulas t
retrieve this information according to which year it is.

What complicates this is that the school year is September 1 year t
July the next, not like the usually Jan to Dec. I need a formula whic
will look up the current date (which could be stored in another cell
and retrieve figures according to which school year this date is in.

If its quite complicated could you plz include some explanation (i'
still gettin 2 grips with excel lol).


Thx a lot for anyone who replies.


Thx


KrisB_baco
 
if you would send me a copy of your workbook i could do the appropriate
formulas.. its just a little difficult to tell you the answer without
knowing what you see at your end.
'email me' ([email protected])
 
something like this might help.
=sumproduct((year(a2:a200)=2003or a1 if a1 has 2003)*(month(a2:a200)>2 or
whatever)*(month(a2:a200)<10)*b2:b200)
for another sheet just add the sheet such as sheet2!a2:a200
 
Back
Top