Hi

It is Excel's way of determining that it is an array formula.
You must not type the brackets yourself, they are automatically entered when
you use Ctrl+Shift+Enter to create the formula, or whenever you edit the
formula.

Note, you will obtain a result as a non-array entered formula, but it will
not be the correct result.

Regards

Roger Govier


nir020 wrote:
Why do you need the curley brackets?

"Roger Govier" wrote:


Hi

An answer from Wales!!!

Try the array formula
{=AVERAGE(IF($A$1:$A$1000="Wales",B2:B101))}
Commit with Ctrl+Shift+Enter and Excel will include the curly braces { }
for you. Do not type them yourself.

Or insert a header row with Country, and Value
Apply DataFilterAutofilter and Select Wales for Column A and use the formula
=SUBTOTAL(1,B2:B1001)

Regards

Roger Govier


nir020 wrote:

Please help

I want to work an average percent from a list of percents in column C row
1-1000 where the value of column B is equal to "Wales". The frequency of
Wales is too large for to manually select the cells so how can I employ the
Daverage function to calculate this,

Thanks