Average & Deviation

R

ross27

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
 
T

Tyro

You could use an Excel standard deviation function and elminate blanks or
zeros by putting it in an array formula.

Tyro
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF(ISNA.. or ISERROR? question.. 3
complex index function not working 7
Standar deviation across sheets help 0
Calculate average in intervals 1
Need help with average/lookup formula 2
Standard Deviation and Averages based on criteria 2
Looping through rows and shifting certain contents 3
Need help with this 1

Top