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
Bookmarks