Array formula or Sumproduct help

Trying to find an array formula or formula using sumproduct to sum the results of the following in a single cell:

=(F4/(SUM(F4,G4)))*D4

for F:F, G:G, D:D

Basically trying to sum the result of that formula for each row of a dataset. Not great with arrays formulas yet, but I feel like I'm right on the edge of cracking this one. Attached has a "wrong" example of the math, a "right" example of the math, and a test area, where I would want the forumlas to reside in P10 & Q10, calculating the same way as K12 & K13, but without the intermediary step of calculating each line, and obviously to be dynamic for any sized array.

Thanks in advance.

-J

I think I'm misunderstanding your reply as well.

Basically, the formula above would be happening on every row of the data, for F4:F(n). I need a formula that will sum the totals of each row's result of that formula. Starting to look like sumproduct is the way to go the deeper I get into this one...

Pl see attached file.

Originally Posted by kvsrinivasamurthy

Pl see attached file.

You sir, are a lifesaver! I must have tried every way of arranging those named ranges into that formula EXCEPT for that. Many thanks.

Oh no! Didn't think about the fact that, division on a line by line basis will require taking cells with a value of zero into account. Adding Pn+Qn will sometimes result in a zero. Going to tinker with Richard's solution and the normal regimen of troubleshooting.... as I notice that my thank you message to him does not appear to have sent.

Pl see attached file with ARRAY formula.