Array/CSE Formulae no longer work.

[InaPickle]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Dear All,

I am using an array formula that worked in excel 2003.
=AVERAGE(IF(AGM!$D$3:$D$240=Paths!B2,AGM!$E$3:$E$240))

It should work, but i get a #DIV/0! message in the cell after pressing CSE.
There are no blank values in the ranges.

Does anyone know how I can get this to work?

Thank you.

 

[Bob Greenblatt]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Dear All,

I am using an array formula that worked in excel 2003.
=AVERAGE(IF(AGM!$D$3:$D$240=Paths!B2,AGM!$E$3:$E$240))

It should work, but i get a #DIV/0! message in the cell after pressing CSE.
There are no blank values in the ranges.

Does anyone know how I can get this to work?

Thank you.

Looks Ok to me. I tried it on a smaller scale and it works fine. Are you
sure there are no text values that look like numbers? You'll get a div0
error if there is no match for paths!b2 to any value in agm!d3:d2409