Actually, sounds like:

Rank is column A, x in column B, so

sumif(B:B,"=x",A:A)/7

change B:B and A:A to true columns.

"Kevin B" wrote:

Would this work?

=COUNTA(E1:E15,"=X")/7
--
Kevin Backmann


"Mark" wrote:

If I have a table that the columns are rankings (1-5) and the rows are
criteria, we now mark the appropiate ranking for the criteria with an 'X'. I
want to add the selected cells and divide by the number of criteria (7). Any
ideas?