| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula result #value! needs to equal zero for average calculation
the lowdown:
column A and C are start and stop times. column b is the difference, calculating minutes to a result. If there is is only one value in column A or C I get the #value! error in column B. In order to calculate a correct average resolution time I need to those #value! errors to equal zero so they are disregarded by my average calculation. Here is my formula: =SUM(G2:G128)/COUNTIF(G2:G128,"<0") Thanks for your help! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula Showing In A Cell Instead of Proper Result | New Users to Excel | |||
| I NEED HELP with the SPELLNUMBER Function | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Copy Paste of Formula Produces Incorrect Result | Excel Discussion (Misc queries) | |||
Threaded Mode
