Have you tried to follow advice from Polish forum?
The one from maxaa posted on July 31st?
Anyway - if you just focus on column N you may write in N2 array formula:
or (as you probably have Polish version of Excel):
It fixes your mistake from N34, because you wrote:
while proper "manual calculation" shall be:
because D25 was not in March, but in February!
As your last post here is August 3rd, while on Polish forum last post was August 1st I'm closing thread on Polish forum. http://www.excelforum.pl/topics2/roz...ch-vt53336.htm
Array formula: ...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
Bookmarks