| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Keeping # of Cells constant in a formula | Excel Worksheet Functions | |||
| Divide selected cells by 1000 | Excel Worksheet Functions | |||
| Formula to sum various cells based on rate factor | Excel Worksheet Functions | |||
| How do i make a formula using cells (divide B3/B5) | New Users to Excel | |||
| how can I duplicate or copy a workbook then divide selected cells. | Excel Discussion (Misc queries) | |||
Linear Mode
