Complex formula to calculate hrs per month

[maggi259]

Hi all,

I am experiencing problems with a formula that IŽd like to create.

I have attached a simplified example. There you can see my tasks, how many hours they will take and when I plan to do them and when they will become due.

Now I want to calculate, how many hours I am going to spent on each task by month.

IŽd really appreciate any tips and help.

Thanks

maggi

[nathansav]

FORUM_D15.xlsxPlease see attached, using array formula, this should assist you.

[maggi259]

Hey, thanks very much,

but somehow it is not working for me. And when I extend the formula the results are not correct. I enterd them with CTR+SHIFT+Enter.

Is there another way to solve this problem? Or what may cause the problem?

Thanks

[nathansav]

What happens, when you come back with errors you need to detail, we cant see it :o)

[maggi259]

Ok, I am sorry.

Please find attached my example. If I filter Transportation and January, it gives me a different result as when I filter it.

I do not get an error, when I do it in my file. Everything is just 0.