Note: In order to use the spreadsheet examples, you need to download Business Functions | ||||||||
DoBetweenX (XMin, XMax, XValues, YValues, [IncOpt], [RangeOperation]) | ||||||||
Do operations on a the Y values of an X-Y data range | ||||||||
This function does sums and averages on the *Y Values* of a series of X-Y data pairs. You define which Y Values are to be included by defining the minimum and maximum corresponding X Values. | ||||||||
Features | ||||||||
..X | Extended | |||||||
Tip | ||||||||
This function is like DoBetween, the only real difference being that floats (exact numbers with decimal points) are accepted instead of just dates. It can therefore be used like DoBetween but where times of the day are involved too. | ||||||||
ExampleDoBetweenX.xls |