Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I'm pretty new to anything more complicated than a simple formula, so please
bear with me. Here's what I'm trying to do (unsuccessfully so far): I have a cell, let's call it B11, that contains a numerical value (0,1,2, or whatever). In the column beneath the cell, I have a further 60 cells (say B7 to B66) that will also contain a numerical value (0,1,2, or whatever). At the bottom of that column, say in cell B70, I want to place a formula that will calculate the percentage average of cells from the range B7 to B66 that exactly match the value in cell B11. (I.e., if 6 of those 60 cells had a value that matched the value in cell B11, I should get 10% in B70, 12 out of 60 would give me 20%, etc.) I haven't figured it out yet, so please help guys :) TNX |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formula for calculating a rolling 12 month average in excel? | Excel Discussion (Misc queries) | |||
calculating a weighted average using formula | Excel Worksheet Functions | |||
calculating a weighted average uisng formula | Excel Worksheet Functions | |||
How do I average a formula without calculating zero values? | Excel Discussion (Misc queries) | |||
How do I create a formula to calculate the average percentage rat | Excel Worksheet Functions |