Okay... In Column O Row 5 through 19...
I need a formula in Column O Row 20 that states:
IF the rows 5:19 have a count that is greater than >=5 then AVG those rows (minus the MAX and MIN #) if the count is <5 then average the rows.
AND I only want it to average the numbers that are not blank!
Please help.
Bookmarks