"ruralkansas" wrote:
It's the ctrl+shift+enter that's the secret!
What, exactly, does that do ??

"Alan Perkins" wrote:
enter this as an array formula
(use ctrl+shift+enter instead of just enter)
=AVERAGE(IF(A1:A9<0,A1:A9,""))

Because the suggested formula is an array formula, and array formulas need
to be confirmed in this manner: CTRL+SHIFT+ENTER
(instead of just pressing ENTER), as Alan suggested

After confirming it correctly, if you look closely in the formula bar,
the entire formula will appear within curly braces {...}
These curly braces are inserted by Excel
(we don't enter these braces manually)

And the CTRL+SHIFT+ENTER needs to be re-done each time to re-enter correctly
the array formula, if the formula is subsequently edited.
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--