formula for avarage with a variable divider
Here is the scenario:
I have a column of 12 cells. Originally, I needed to calculate the column avarage and I did this: SUM (A1:A10)/12. Now, some of these cells are zeros and I need to calculate the column avarage excluding them. let's say that out of the 12 cells 3 are zeros. my formula would be: SUM(A1:A10)/9. Because the number of cells that have zeros is always changing I need a formula that identifies the cells with zeros, subtracts it from 12 and divides the sum to it. Thank you |
formula for avarage with a variable divider
Use this as the denominator:
=COUNTIF(A1:A10,"<0") marius wrote: *Here is the scenario: I have a column of 12 cells. Originally, I needed to calculate the column avarage and I did this: SUM (A1:A10)/12. Now, some of these cells are zeros and I need to calculate the column avarage excluding them. let's say that out of the 12 cells 3 are zeros. my formula would be: SUM(A1:A10)/9. Because the number of cells that have zeros is always changing I need a formula that identifies the cells with zeros, subtracts it from 12 and divides the sum to it. Thank you * --- Message posted from http://www.ExcelForum.com/ |
formula for avarage with a variable divider
It works. Thanks a lot. *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
All times are GMT +1. The time now is 08:33 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com