Hi Jack,

try the tips on the Chip Person web site

hope this helps
regards from Brazil
Marcelo

"Jack" escreveu:

Hi!

I have a spreadsheet with a column that is either Red or Blue, and I'd like
to do AVG, MIN, MAX, and MEAN for the column adjacent to it. Is there a way
to do these calculations based on the adjacent cell of Red or Blue? I'd sort
the data and do it that way, but I need to do this with a number of different
columns, so I need to figure out a way to make it conditional.

Thanks and hope that makes sense!