Jason Morin

Posts: n/a

One way:

=IF(COUNT(A1:A10),AVERAGE(A1:A10),"")

HTH
Jason
Atlanta, GA

-----Original Message-----
I am using the average function! But when there is no
data in the cells to
average it returns the #DIV?0! how can I avoid this I
would like it to be
blank
.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Using The Average Function if a cell has NA	carl	Excel Worksheet Functions	6	May 21st 23 07:46 PM
Average Function help	Cheech	Excel Worksheet Functions	4	January 24th 05 03:44 PM
How do I nesting subtotal function within average function in Exc	Amy Yeh	Excel Worksheet Functions	4	January 19th 05 06:23 PM
Average function with If	Danny	Excel Worksheet Functions	2	December 3rd 04 06:27 PM
Using Average function when number is zero	Deb	Excel Worksheet Functions	3	November 6th 04 01:01 AM

All times are GMT +1. The time now is 07:01 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us