I am looking for a formula that does not seem to exist within the
existing range.

I am an intermediate level user of Excel

I often use the SUMPRODUCT formula to calculate the product value from
two columns but I now a requirement for what might be described as a
SUMDIVISION function which acts in exactly the same way as SUMPRODUCT
but divides rather than mulitplies the values between two associated
columns.

I can achieve the desired result by manually entering the operators -
e.g. =N11/$J11+N12/$J12+N13/$J13+N14/$J14+N15/$J15+N16/$J16 and so on
but there does not seem to be a formula such as:
SUMDIVISION ($J11:$J16, N11:N16)

There is a maximum limit to the number of characters you can enter
intp a formula. Because the columns are quite large I exceed this
limit

Doe anybody know a shorthand method of writing the formula to included
large arrays of cells in a shortform so I do not exceed the character
limit?

Thanks in advance for any advice offered


Peter Davidson
Alderley Edge
NW. England