Posted to microsoft.public.excel.programming

FPJ

external usenet poster

Posts: 19

AVERAGE formula. PLEASE HELP!!

I know this is very simple problem to most, if not all, of you here but I am
trying to figure out how to create the formula to get the average of column B
of reports created in a certain month (ex. July). Please note that some cells
in column B have the #VALUE! and the dates in column A are in the x/x/xxxx
format. Please help. Thanks.

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
I get the #div/0! when using the formula =average(d33:d48)	Glen	Excel Discussion (Misc queries)	4	September 27th 08 01:18 PM
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
formula average	Melle	Excel Discussion (Misc queries)	3	October 6th 05 03:20 PM
Average Formula	Anthony	Excel Discussion (Misc queries)	3	July 14th 05 04:38 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 09:03 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us