|
|
|
|
#1
04-18-2012, 12:56 PM
|
|||
|
|||
formula divide by serio error
=SUMIF(DO2
 O145,"<>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
04-18-2012, 02:29 PM
|
||||
|
||||
|
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 |
Windows 7 32bit 
Office 2010 32bit
Hybrid Mode