Using the followiing SUMIF and COUNTIF functions I am able to get the # of occurences and the avg in relation to specific cells. How can I get largest and the smallest number in the same range?
dblVal = Application.SumIf(rngC, rng, rngD) ' - Application.SumIf(rngC, rng, rngB)
dblCnt = Application.CountIf(rngC, rng)
dblAvg = dblVal / dblCnt
MsgBox dblAvg
dblVal = Application.SumIf(rngC, rng, rngD) ' - Application.SumIf(rngC, rng, rngB)
dblCnt = Application.CountIf(rngC, rng)
dblAvg = dblVal / dblCnt
MsgBox dblAvg