ExcelBanter - Formula to add selected cells then divide by constant factor

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Formula to add selected cells then divide by constant factor (https://www.excelbanter.com/excel-discussion-misc-queries/203413-formula-add-selected-cells-then-divide-constant-factor.html)

Mark

Formula to add selected cells then divide by constant factor

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?

Kevin B

Formula to add selected cells then divide by constant factor

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?

Sean Timmons

Formula to add selected cells then divide by constant factor

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?

All times are GMT +1. The time now is 04:07 AM.