Quick follow up question as well...This formula copies all blank cells as zeros instead of null strings.

The difficulty with this is that unless a score is entered the averages in the dissagregated area are skewed. For example, if out of 5 students only one student's score is entered (For example, 100%), the sheet will read all other scores as zeros and report an average of 20%.

I have used a formula similar to =IF(A1="","",A1) in the past to deal with this issue, but I am not sure how to integrate it into the formulas used to dissagregate data.

Any suggestions?

Thanks again.