Determine month's of report cells to add to calculation

[rdjohnso]

I am trying to populate these four cells in my report..
from the monthly cells above... but based upon if it is the
current year or the next year...
Screenshot

The Monthly Hours and Cost are already calculated via a Function.. so I am unsure how I should do this....

I would typically do something like this....
=[MonthlyHours1]+[MonthlyHours2]+[MonthlyHours3]+ .....

But... I have to dynamicly determine if the current month and subsequent months fall within the current or future year...

Please advise...

Thanks

Ron

 

[Pat Hartman]

I don't really understand your question but I do have a couple of things to say.

You are thinking spreadsheet and you should be thinking relational database. Tables do not contain cells and record order has no meaning. Instead of having twelve columns, one for each month, you need twelve rows.