I would describe myself as an intermediate Excel user

I am familiar with the use of formulas to increase the productivity of Excel.

One common formula I have used frequently is SUMPRODUCT which calculates the
sum of two arrays.

However I have a requirement for a formula that might be described as
SUMDIVISION - i.e. exactly the same function as SUMPRODUCT but dividing
instead of multiplying.

I have looked in the formula lists but I cannot find one that fits the bill.
I have constructed this formula manually (a real hassle!) but you can only
have so many characters in your formula and I have run out - these are
relatively large arrays I am dealing with.

Does anybody have any advice they can offer?