View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
joeu2004 joeu2004 is offline
external usenet poster
 
Posts: 2,059
Default SUMDIVISION formula function - does it exist?

On Jan 2, 4:02*pm, (Peter A Davidson) wrote:
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 associate dcolumns.


Someone is likely to point out that this question has been asked (by
you under the name "padav") and answered earlier this morning. Odd:
I find the thread when I do a search of Google Groups. But I do not
see the thread in the normal list of threads in this newsgroup --
which might explain the OP's reposting.

Anyway, the OP has add some detail....

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)


Well, first, I would think you want SUMDIVISION(N11:N16, $J11:$J16).
That can be written simply as:

=sumproduct(N11:N16/$J11:$J16)