Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-30-2010, 02:46 AM
jim831 jim831 is offline AverageIf and Div/0 help needed Windows 7 AverageIf and Div/0 help needed Office 2007
Novice
AverageIf and Div/0 help needed
 
Join Date: Oct 2010
Posts: 4
jim831 is on a distinguished road
Default AverageIf and Div/0 help needed

I would like to Average B3:U3 if there is any data stored there and return the average in X3. I keep getting the "DIV/0" if no data is stored. how do i Average B3:U3 when data is present, but return 0 if there is no data. Thanks jim
Reply With Quote
  #2  
Old 10-30-2010, 04:04 AM
Kimberly Kimberly is offline AverageIf and Div/0 help needed Windows 7 AverageIf and Div/0 help needed Office 2010 (Version 14.0)
Expert
 
Join Date: May 2010
Posts: 517
Kimberly is on a distinguished road
Default

=iferror(average(b3:u3),0)
Reply With Quote
  #3  
Old 10-30-2010, 04:54 AM
jim831 jim831 is offline AverageIf and Div/0 help needed Windows 7 AverageIf and Div/0 help needed Office 2007
Novice
AverageIf and Div/0 help needed
 
Join Date: Oct 2010
Posts: 4
jim831 is on a distinguished road
Default

thankyou very much
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Help-urgent help needed immediately munstershug PowerPoint 1 05-01-2010 11:27 AM
Help needed with assignment ccmystery Outlook 0 04-09-2010 05:59 AM
AverageIf and Div/0 help needed help needed!!! thunder14 Word 1 10-17-2009 02:57 PM
AverageIf and Div/0 help needed Syntax help needed blazzercat Excel 3 07-09-2009 02:15 PM
AverageIf and Div/0 help needed Help needed :) thechief55 PowerPoint 1 04-28-2009 01:25 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:50 AM.


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