Hi!

With the formula entered in the cell........

Select that cell
Press function key F2
Hold down both the CTRL key and the SHIFT key then hit ENTER.

When done properly Excel will enclose the formula in squiggly braces { }.
You cannot just type these braces in. You MUST use the key combination.
Also, any time you edit the formula (which is what you're doing when you
press F2) you MUST re-enter the formula using the key combination.

Also I'm not sure why the range is A4:A32 when the date column ends
with A31?

But you have an entry is B32. I'm assuming this gets updated for each new
month. Currently it's for June which has 30 days and 6/30 is the last date
in A31. If it were for July then wouldn't 7/31 be in A32? At least, that's
the impression I get just looking at the sheet but it's not MY sheet so I'm
just taking my best guess at what you're doing! If I'm wrong just change the
references!

Biff

"nander" wrote in
message ...

Well let's see moved my cursor to the cell. Right clicked Pressed
CTRL,SHIFT,ENTER then and pasted the copied fromula in the cell. Got
#Value. Not sure what I did
wrong.=AVERAGE(IF((ISNUMBER(A4:A32))*(B4:B32<0),B 4:B32))

Also I'm not sure why the range is A4:A32 when the date column ends
with A31?


--
nander
------------------------------------------------------------------------
nander's Profile:
http://www.excelforum.com/member.php...fo&userid=6156
View this thread: http://www.excelforum.com/showthread...hreadid=550391