Hello,

I have some student test data that I've entered into excel. I have represented the male student test data by changing the font color to green and the female test data by changing the font color to red.

I'm wanting to average the test data based upon gender (green data averaged & red data averaged).

From my basic internet research, I've gathered that I'm going to need to go into VBA and create a user defined function.

Is there anyone out there that could assist me with that?

Thanks,
Mike
Middle School Teacher