My question was more of a typo test:
=AVERAGE(IF(Northeast!B1:B1000<0,Northeast!B1:B10 00,""))
(just checking if B1:B1000 was used in both portions of the formula:
Max wrote:
Did you adjust the range in each spot?
I'm not sure what you mean.
Just a shot at re-tracing the thread relevant to the above exchange .. I'm
not sure if the phenomena you're facing, assuming the formula's now
correctly array-entered, was because the cell references were not fixed,
i.e. you copied (to other cells):
=AVERAGE(IF(Northeast!B1:B1000<0, Northeast!B1:B1000,""))
instead of:
=AVERAGE(IF(Northeast!$B$1:$B$1000<0, Northeast!$B$1:$B$1000,""))
Some strange things/results could happen <g if the cell references are not
fixed where they should be.
Do hang around for Dave's comments, though ..
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
--
Dave Peterson
|