SumDiv function

Range Operations category - Range Sum family Home 
What the name means"Sum of one range divided by another"
SyntaxSumDiv ( Values1, [Values2] )
DescriptionDivided Values1 by corresponding items in Values 2, then adds them all together
VariableType or ValueDescription
Inputs: (2)
1 Values1 Range of Floats (numbers) The first range of numerical values
2 Values2 Range Of Floats (Optional) The second range of numerical values (Optional)
Output:
Return Value Result Float The result of the function, expressed as a number.
Range Handling and Constraints

This function has range inputs that are subject to range handling procedures to help reduce input errors and increase flexibility and speed. Click here to see more.

Examples
  • Preview of the SumDiv example.
  • The above spreadsheet can be accessed from the Quick Reference (on the Business Functions menu), on the Examples menu, or in the Business Functions\Component Examples directory