#1
|
|||
|
|||
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
|
#2
|
|||
|
|||
=iferror(average(b3:u3),0)
|
#3
|
|||
|
|||
thankyou very much
|
|
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 |
help needed!!! | thunder14 | Word | 1 | 10-17-2009 02:57 PM |
Syntax help needed | blazzercat | Excel | 3 | 07-09-2009 02:15 PM |
Help needed :) | thechief55 | PowerPoint | 1 | 04-28-2009 01:25 PM |