if cell is red, don't include in average

[rcr1991]

thanks to the help of forum members i've firgured out how to loop through columns comparing each cell to the avg and std dev of the column. if they are outliers, then i color the cell red and move on.

now i am trying to figure out how to make an average of all non-highlighted cells. cell interior is colored red.

so in plain speak, the idea: average (range) for each non-red cell. should i start with IF?

eg: If cell is not red, then add, keeping count of number of cells added so I can get average?


suggestions or ideas?

 

[Oaktree]

Chip Pearson has code here http://www.cpearson.com/excel/colors.htm for how to sum and count by color. You should be able to use those formulas to compute your average.

 

[rcr1991]

thanks!