Can anyone provide a way to perform the following function. I've been told
there is a way to do with "sumproduct" which I use.

Column A and B each have values in 100+ rows. Each cell in the column has
one of several different #'s in them.

If there is a "1" in the cell of a given row in in column A and a "2" in the
cell of the same row in column B, what is the average of values cells of the
same row in column C. i.e. i.e. give the average of values in column C
restricting to rows where there is a "1" in column A and a "2" in column B.

Can this function be done in Excel? Or am i stuck with SPSS or some such.

anand