Posted to microsoft.public.excel.misc

sdmccabe

Posts: n/a

Average

I am totaling a column of percentage values that also include cells (from a
linked sheet) that display the error alert #DIV/0! in the cells that have no
appropriate value from the linked sheet. How can I total the column (I want
the average percentage) and ignore the alert and display the correct average.
Also, isnt there a way to control the type of error alert that is displayed
in each cell?

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
rolling average	William Okumu	Excel Worksheet Functions	5	May 25th 06 03:49 PM
Formula for determing average based on weighting	John Sullivan	Excel Worksheet Functions	2	December 16th 05 08:21 AM
plotted Average	Micayla Bergen	Charts and Charting in Excel	4	July 15th 05 12:13 PM
What is this kind of average called?	havocdragon	Excel Worksheet Functions	3	June 24th 05 05:10 PM
Average Formula with Criteria	PW11111	Excel Discussion (Misc queries)	1	June 10th 05 02:22 PM

All times are GMT +1. The time now is 06:50 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us