I guess what i'm asking is, how do i get this array formula to ignore blank
cells when it averages the data?


"bbddvv" wrote:

Okay, that worked BUT how do i take into account blank cells (i.e. cells
where a student was not required to take a certain test). These blank cells
are being counted as zeros in the averaging formula, thus skewing the results
(they should simply not be counted)