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

How Do I Combine Rankings for Multiple Categories? 1
Need Help Creating a Macro to Multiply Cells by a Constant Number 5
Averaging a row & dividing by only the qty. of cells with a value 3
Excel 2010 not allowing me to paste as formula 5
Can i avoid "00.00" when the result of a calculation is 0? 4
Function or formula to add different formatted cells 1
Date vs Time of Day, if x hrs (8-4) divide by?.. 1
Divide by the minimum non-zero number in a range of cells 21

Top