I don't have any more guesses.

Wowbagger wrote:

"Dave Peterson" wrote in message
...
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:

Yes. As were B:B and B:B

--

Dave Peterson