Posted by David on November 30, 2001 7:59 PM
I'd like to average the numbers in column B if certain criteria is met in the adjacent cell in column A. For instance, assume A1:A6 is red, blue, red, blue, red, blue and B1:B6 is 2,4,6,3,5,7. What formula could I put in a cell in column C that would average only the numbers in B that have "blue" next to them in A? Is it possible?