Posted to microsoft.public.excel.worksheet.functions

Curtis

external usenet poster

Posts: 181

Averageif is not working

why is the formula below not working...It returns the #VALUE!

=AVERAGEIF((C5:C12,C15:C18,C21:C30,C33),"<0")

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
AVERAGEIF	T. Valko	Excel Worksheet Functions	9	July 15th 09 07:01 PM
Help with Averageif Formula (don't think I should use Averageif)	MUmfleet	Excel Discussion (Misc queries)	5	April 9th 09 04:53 PM
AVERAGEIF	Tung Nguyen	Excel Worksheet Functions	3	April 4th 09 01:29 AM
AverageIF with cell refenrence as criteria is not working	Bart Geerling	Excel Discussion (Misc queries)	4	November 22nd 07 08:36 PM
AverageIF	coastal	Excel Discussion (Misc queries)	1	November 13th 07 11:28 PM

All times are GMT +1. The time now is 07:42 AM.

About Us

"It's about Microsoft Excel"