Ryder

Posts: n/a

How do I use an average function, not counting cells containing a

I am working on setting up a spreadsheet that will have monthly data and from
time to time one of the months will have a zero value. Off of this data I
want to do an average, but not use the cells that contain zeros. This is a
monthly report and there are 90 of these monthly tables, so you can see why I
want to figure out how to automate this.

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
Using the average function	LostNFound	Excel Worksheet Functions	5	March 16th 05 12:45 PM
How do I nesting subtotal function within average function in Exc	Amy Yeh	Excel Worksheet Functions	4	January 19th 05 06:23 PM
Counting Function Dilemma	Simon Lloyd	Excel Worksheet Functions	0	November 8th 04 03:13 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:23 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us