From: Lars-�ke Aspelin on
On Thu, 20 May 2010 20:38:45 +0100, Odin
<Odin.63b8d89(a)> wrote:

>I have the following formula that I would like to shorten it. Is it
>To following is just an idea but doesn't work on excel.
>I wanted to use SUMPRODUCT but it only take contiguous array. Thanks
>for any input.
>PS: I can not use array C1:C21 because other cells within it may equal
>to $A$1 which will return incorrect result. And the 3rd part, {1,2...}
>would be too long.

Try this formula, it is 19 characters shorter than the one you have:


Hope this helps / Lars-�ke