What is the double dashes do in the formula? I can't find a reference for that anywhere....

Thank you in advance,
Stan



Bob Phillips wrote:

How to Average elapsed time values?
24-Jul-08

Sounds like they are text. Try this

=AVERAGE(IF(D1:D100<"",--(D1:D100)))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.
Excel will automatically enclose the formula in braces (curly brackets), do
not try to do this manually.
When editing the formula, it must again be array-entered.



--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"MTB_AR" wrote in message
...

EggHeadCafe - Software Developer Portal of Choice
Resolving the ASP.NET Database Security Dilemma
http://www.eggheadcafe.com/tutorials...spnet-dat.aspx