The ranges in the above tip's formulas are wrong. Should be 3:7 not 1:5. Poor attention to detail Exceltip.com.