Array formulas

[Amy Beryl]

Hi all -

I have just discovered array formulas which appear to answer an averaging issue I have. One question though can I add to an array average formula an initial test to check if all the fields are zero.

For example, the array formula I wrote that works is:

{=average(if(h24:j24=0,h24:j24))}

I would like to preceed this average formula with some kind of test like:

=if(h24:j24=0,0 then the arravy average formula.

I have tried various formula constructions but none of them work and I don't want to go to macros.

Any help would be appreciated.

Amy

 

[Sektor]

What's the point of this formula?

 

[Amy Beryl]

The array average formula works if there is at least one number contained in the range, but it returns a #DIV! if all the cells are zeros. I want to test for this condition before the array activates.

 

[Amy Beryl]

Any iideas?

Amy