Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
formula help needed for averages
=SUM(C21:C25)/COUNTIF(C21:C25,"0")
equals 5 Cheers! Brad "phil-rge-ee" wrote in message ... I have a cells C21 thru C45 that have numbers in them. I need to add them all together and then divide by the number of cells that have a number greater than 0 in them. This would be used to get an average number. If the cell is 0 then I don't want to include it in the dividing process. Example: C21 is 5 C22 is 3 C23 is 0 C24 is 7 C25 is 0 I would need the formula or VB script to add the numbers then divide by 3 (not divide by 5 - eliminating the cells with 0 in them) So the answer in the example here would be 5, not 3. (15 divided by 3). Thanks for any help. Phil |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula for averages | Excel Discussion (Misc queries) | |||
help with averages formula | Excel Discussion (Misc queries) | |||
help with averages formula | Excel Discussion (Misc queries) | |||
averages formula | Excel Worksheet Functions | |||
averages formula | Excel Worksheet Functions |