| Home |
| Search |
| Today's Posts |
|
#7
|
|||
|
|||
return a zero for error
You didn't mention this additional requirement in your original post. Since
these are grades, I will assume that negative numbers cannot occur. In that case =IF(COUNTIF(B5:B20,"0"),SUMIF(B5:B20,"0")/COUNTIF(B5:B20,"0"),0) may be closer to what you are looking for. Jerry "Pete Cumberland" wrote: Hi Jerry, I tried your solution (many thanks) but as there may be blanks in the range (represented by zero) I get an incorrect average. Pete "Jerry W. Lewis" wrote in message ... If in the workbook this will be repeated many times or involve a much larger range, then it might recalculate faster to cut out the math =IF(COUNT(B5:B20),AVERAGE(B5:B20),0) Jerry |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Intervals of 1 Numeric value in a Row and Return Count down Column | Excel Worksheet Functions | |||
| Huge problem with "if" formula's | Excel Discussion (Misc queries) | |||
| Excel - return a picture or range rows as the result of a formula | Excel Worksheet Functions | |||
| How do create a formula to evalute a # to return 1 of 4 conditions | Excel Worksheet Functions | |||
| if the value of a cell in a range is not blank, then return the v. | Excel Worksheet Functions | |||
Threaded Mode
