Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-18-2012, 12:56 PM
vthomeschoolmom vthomeschoolmom is offline formula divide by serio error Windows 7 32bit formula divide by serio error Office 2010 32bit
Novice
formula divide by serio error
 
Join Date: Feb 2012
Posts: 23
vthomeschoolmom is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 04-18-2012, 02:29 PM
Colin Legg's Avatar
Colin Legg Colin Legg is offline formula divide by serio error Windows 7 32bit formula divide by serio error Office 2010 32bit
Expert
 
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default

Hi,

You're using XL 2010 so this should work:
Code:
=IFERROR(AVERAGEIF(DO2:DO145,"<>0"),0)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
divide page into 4 parts aclark17 Word 4 01-17-2012 09:04 AM
formula divide by serio error 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

Other Forums: Access Forums

All times are GMT -7. The time now is 03:25 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft