G
Guest
I'm looking for a way to total (SUM) the lowest X number of values in a given
range of values. For example, I have a row of 15 values. I'd like to do
some analysis and determine what the total and average is for the lowest 5
values, lowest 10 values, or whatever number of values I desire. Is there a
function or formula that will help me accomplish this?
range of values. For example, I have a row of 15 values. I'd like to do
some analysis and determine what the total and average is for the lowest 5
values, lowest 10 values, or whatever number of values I desire. Is there a
function or formula that will help me accomplish this?