Posted to microsoft.public.excel.misc

Darren

Posts: n/a

Averaging 14 Cells

Hello - I am trying to get the average of 14 cells on 14 different sheets,
i.e. cells C14 on worksheets 1-14. The problem I am running into is that
some of these cells may contain no data and so I am getting the #DIV/0!
error. Help...

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
checking that cells have a value before the workbook will close	kcdonaldson	Excel Worksheet Functions	8	December 5th 05 04:57 PM
how do i protect cells in a shared worksheet	Debi	Excel Discussion (Misc queries)	3	September 30th 05 11:15 PM
Fill cells from non-adjacent cells	Abes	Excel Discussion (Misc queries)	2	March 25th 05 01:15 PM
Help adding text values	Texas-DC_271	Excel Worksheet Functions	7	January 15th 05 11:14 PM
Convert data type of cells to Text,Number,Date and Time	Kevin	Excel Worksheet Functions	1	December 31st 04 12:57 PM

All times are GMT +1. The time now is 08:06 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us