Formula to add selected cells then divide by constant factor

M

Mark

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?
 
S

Sean Timmons

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

RPG Initiative Segment Counter help! 0
RANKING alters when data is filtered 4
Ranking without skipping ranks and percentile 3
Rank Function Help Needed 7
Page numbering with Merged Document and IF statements 1
Solution to tricky problem of showing exactly Top N rows in Pivottable 0
Copy addition formula of non-consecutive horizontal cells 2
Standard Deviation and Averages based on criteria 2

Top