Need help with AVERAGE formula

[Guest]

With Frank's help, am trying a new formula to average a field of 13 numbers, 9 of which contain zeros that I want the system to ignore, and 4 of which have numbers. It's not working, as I'm getting the #value! error message instead of my average. Here's my current formula, what's wrong

=AVERAGE(IF(D618<>0,D618)

Thanks in advance for your assistance! Please email me at work ([email protected]) if you have more info for me
Jessica

 

[Norman Harker]

Hi Jessica!

It's an array formula.

Enter the formula by pressing and holding down Ctrl + Shift and then
pressing Enter.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Paul B]

Jessica, you will have to enter it using Ctrl+shift+enter
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address to reply by email **

With Frank's help, am trying a new formula to average a field of 13

numbers, 9 of which contain zeros that I want the system to ignore, and 4 of
which have numbers. It's not working, as I'm getting the #value! error
message instead of my average. Here's my current formula, what's wrong?

=AVERAGE(IF(D618<>0,D618))

Thanks in advance for your assistance! Please email me at work

([email protected]) if you have more info for me.

 

[Frank Kabel]

Hi Jessica
as posted via private mail enter this as array formula with
CTRL+SHIFT+ENTEr instead of only a single ENTER