Brad

Posts: n/a

Array

Thanks for taking the time to read my quesiton.

I typed in the word array into Excel Help and found this item

"About array formulas and how to enter them"

I am trying to duplicate the first example and cannot

Ex: =Average(if(C5:C14="Europe",D5:D14))

I tried something similar to this (diff cell ref) and I get #VALUE

Do I need to check off an addin or something?

Thanks,

Brad

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
Excel array formulas	Les Gordon	Excel Discussion (Misc queries)	1	September 3rd 05 04:12 PM
Pass an array to Rank	Biff	Excel Worksheet Functions	12	June 29th 05 04:15 PM
Match / Vlookup within an Array formula	Hari Prasadh	Excel Discussion (Misc queries)	3	February 3rd 05 04:37 PM
Formula to list unique values	JaneC	Excel Worksheet Functions	4	December 10th 04 12:25 AM
VBA Import of text file & Array parsing of that data	Dennis	Excel Discussion (Misc queries)	4	November 28th 04 10:20 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us