Say you have col A = "Red" or "Blue"
colB = your values
cell C2 = "Red" or "Blue"
In D2 thru G2, enter formulae:
=AVERAGE(IF(A:A=$C2,B:B))
=MIN(IF(A:A=$C2,B:B))
=MAX(IF(A:A=$C2,B:B))
=MEDIAN(IF(A:A=$C2,B:B))

HTH
--
AP

"Jack" a écrit dans le message de news:
...
Sorry - I guess my original post wasn't clear. The cells aren't colored,
"Red" and "Blue" are the actual entries in the cells. I just need to do
calculations on adjacent cells based on whether they are in the "Red" or
"Blue" group.