Posted to microsoft.public.excel.misc

Glen

external usenet poster

Posts: 68

I get the #div/0! when using the formula =average(d33:d48)

I was wanting to know the formula for this subject so the cell would not show
this error. it comes up when there is no number in the cell. what am I doing
wrong. I know there is a formula but can't remember it. thanks
--
Glen

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
Average formula	Pammy	Excel Discussion (Misc queries)	1	June 26th 08 03:51 AM
A formula to AVERAGE IF but only average a set number of values	[email protected]	Excel Worksheet Functions	2	January 31st 08 08:28 PM
average in formula?	fivermsg	Excel Discussion (Misc queries)	7	March 13th 06 11:59 PM
Average formula	thomas wald	New Users to Excel	2	July 12th 05 02:49 PM
how does one convert text to a formula "average(A:A)" to =average(	phshirk	Excel Worksheet Functions	4	April 14th 05 01:20 AM

All times are GMT +1. The time now is 05:23 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us