Hello All,
I have a Cumulative Percentage Table with which I would like to average the percentage for months 1-12. I currently sum the columns & divide by the number of months of activity but the numbers do not make sense. Can someone suggest a more robust approach.
Thank you.
Re: Methodology For Average
numbers look fine...its doing exactly what you are telling it to do...sum up the row then divide by a user defined number.
what else are you looking for it to do?
Re: Methodology For Average
Thank you for your help.
Re: Methodology For Average
You might like to change the formula in B17 to
=SUMIF(B4:B15,"<>0")/MAX(1,(COUNT(B4:B15)-COUNTIF(B4:B15,"=0")))
and fill across. This will avoid having to work out how many months to divide by.
Re: Methodology For Average
QuoteCan someone suggest a more robust approach
....[pt]*[/pt]
Don’t have an account yet? Register yourself now and be a part of our community!