Behavior of Offset function in an array formula

Dear Experts,

I have noticed a strange behavior in Offset function when used in an array formula. The problem is that I used Offset to create an array of the non blank cells from a range and when I evaluate the formula in edit mode (by selecting the whole formula and pressing F9) it evaluates to the array that I want. However, when I use the same formula with the SUM function or COUNT function or whatever, it only takes the first element.

Is this a normal behavior of the Offset function?? or am I missing something?
Please refer to the attached workbook to get a grip of what I am experiencing.

Regards,
Mohammad