ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Average & Deviation (https://www.excelbanter.com/excel-worksheet-functions/173024-average-deviation.html)

ross27
Average & Deviation
 
I am trying to average & obtain Sd based on last 10 results entered into
Sheet. the sheet is constantly being added to.
Some cells contain Blanks, which are distorting my results
Any suggestions
Currently using the below to calculate average but doesnt allow for blank
cells
=SUMIF('DQ Bin No 1'!$AK:$AK,""&MAX('DQ Bin No 1'!$AK:$AK)-10,'DQ Bin No
1'!T:T)/COUNTIF('DQ Bin No 1'!$AK:$AK,""&MAX('DQ Bin No 1'!$AK:$AK)-10)

Any suggestions

Tyro[_2_]
Average & Deviation
 
You could use an Excel standard deviation function and elminate blanks or
zeros by putting it in an array formula.

Tyro

"ross27" wrote in message
...
I am trying to average & obtain Sd based on last 10 results entered into
Sheet. the sheet is constantly being added to.
Some cells contain Blanks, which are distorting my results
Any suggestions
Currently using the below to calculate average but doesnt allow for blank
cells
=SUMIF('DQ Bin No 1'!$AK:$AK,""&MAX('DQ Bin No 1'!$AK:$AK)-10,'DQ Bin No
1'!T:T)/COUNTIF('DQ Bin No 1'!$AK:$AK,""&MAX('DQ Bin No 1'!$AK:$AK)-10)

Any suggestions




All times are GMT +1. The time now is 07:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com