Related:
- Excel Help with Percent calculations
- How to calculate position in excel ✓ - Forum - Office Software
- How to calculate vat in excel - How-To - Excel
- Excel vba calculator - How-To - Excel
- Excel run out of resources while attempting to calculate - How-To - Excel
- Calculation of positions in excel ✓ - Forum - Excel
3 replies
Oterwill
- Posts
- 5
- Registration date
- Tuesday February 24, 2009
- Status
- Member
- Last seen
- February 25, 2009
At first I didnt understand, but then I did some of my own example and see what you mean. I used three formulas with differeing results when the 0% is deleted and left with a blank.
I started with AVERAGE(B2:AR2) and tested it against SUM(B2:AR2)/COUNTA(B2:AR2): which is just the average formula in its mathimatical simplest. sum of the numbers divided by sum of the number of data points. I thought that the counta would count the blank, but as I should have known it only counts if there is something in the cell. So this however gave me the same result when the 0%s were omitted.
I then did the same thing, but to count the data points, as I assume you have data in each cell from B2-AR2, I used a more complicated way to count. I did:
SUM(B2:AR2)/(COLUMN(AR2)-COLUMN(B2)+1)
This worked when 0%s were omitted since it wasn't counting anything but the column reference numbers which are absolute. the +1 is included in the end because the number is inclusive.
(obviously format the cell as a Percent to get the %)
Let me know if it helps or solves your problem:
OT
I started with AVERAGE(B2:AR2) and tested it against SUM(B2:AR2)/COUNTA(B2:AR2): which is just the average formula in its mathimatical simplest. sum of the numbers divided by sum of the number of data points. I thought that the counta would count the blank, but as I should have known it only counts if there is something in the cell. So this however gave me the same result when the 0%s were omitted.
I then did the same thing, but to count the data points, as I assume you have data in each cell from B2-AR2, I used a more complicated way to count. I did:
SUM(B2:AR2)/(COLUMN(AR2)-COLUMN(B2)+1)
This worked when 0%s were omitted since it wasn't counting anything but the column reference numbers which are absolute. the +1 is included in the end because the number is inclusive.
(obviously format the cell as a Percent to get the %)
Let me know if it helps or solves your problem:
OT
with the following for example let me say cell a3+d3+d4 maube I get the answe as 40 then I want that 40 on the other cell maybe f3 to be 2 as a level in other wors from 40 to 49 must be level 2 automatically , I need a formular to do it
please help
Example: I have a total of 56 cars, I can drive daily. (Next to each car listed separately, car 1, car 2, car 3, etc, I list the # of passengers in that car if it were used that day). I want the formula to count the # of cars used that day (based on the cells that have passengers in them) and divide that total by 56.