Dear Xor,
It will be easier if you don't mind to open up my example sheet attached.
In the first tab, the formula worked perfectly with the right result.
In the second tab, when I took out the blank column and changed the formula. The result failed.
It maybe a bit hard to put this into words.
Really appreciate your help.
Thank you