#1
|
|||
|
|||
formula divide by serio error
=SUMIF(DO2O145,"<>0")/COUNTIF(DO2O145,"<>0")
If no value in the column is not zero, then I get a divide by zero error of course. How do I write this formula to have the value be ZERO in this case? I am a bit of an excel noob. Thanks |
#2
|
||||
|
||||
Hi,
You're using XL 2010 so this should work: Code:
=IFERROR(AVERAGEIF(DO2:DO145,"<>0"),0) |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
divide page into 4 parts | aclark17 | Word | 4 | 01-17-2012 09:04 AM |
Microsoft office 2010 error 2908 and error 1935 !!!!!!heeeeellpppp!!!!!!!!! | bennypryde | Office | 1 | 01-05-2012 03:33 PM |
Runtime error 5487 - Word cannot complete the save to to file permission error | franferns | Word | 0 | 11-25-2009 05:35 AM |
Divide by zero error | doublejoy | Excel | 1 | 08-22-2009 03:10 AM |
Receive error cannot open this form because an error occurred in BCM 2007 | bornhusker | Outlook | 0 | 06-01-2009 10:28 AM |