P
Peter A Davidson
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
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