Perfect!!!
Why?
"Peo Sjoblom" wrote:
They need to be entered with ctrl + shift & enter
select the cell with the formula, press F2, press
ctrl + shift & enter at the same time
Regards,
Peo Sjoblom
"Brad" wrote in message
...
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
|