Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
Averaging a total in excel with a slight problem?
I know that by using "=average()" I can have a cell for each day of the month and as I enter a value in each cell it will average the total of cells day to day. The problem I have is one cell contains 3 days worth of data.
Ex. A1- 50
A2- 50
A3- 50
A4- 125 (50+50+25)
A5- 50
The average calculates it as 50+50+50+125+50/5= 65. I need it to count the one cell as 3 entries as in 50+50+50+125+50/7=46.4. I can not enter the data in any other cell but still need to calculate like it was. Thanks ahead of time if you can figure it out.
It just adds 2. As in instead of 65 it gives me 67. Any other ideas...
2 Answers
- expletive_xomLv 78 years agoFavorite Answer
that A4 cell was a bad idea
so if =AVERAGE(A1:A5) gives you the wrong 65
then an Average is simply a SUM 325 divided by a COUNT in this case 7...but if you look at it, the count is 5....so you need to add 2
this should work with a copy&paste
=SUM(A1:A5)/(COUNT(A1:A5)+2)
let me know how it works.
- FlashDarknessLv 68 years ago
expletive_xom is correct. Did you enter it exactly as written? Parentheses in the right place?
=SUM(A1:A5)/(COUNT(A1:A5)+2)
