Re: [libreoffice-users] averaging with missing values

Hi Regina,

Le 15/02/2014 17:49, Regina Henschel a écrit :
> If the cells are really empty or have a function call that results in a
> text, then such cells will not be counted by the AVERAGE function. If
> the cells contain a formula, which results in 0, then you can use
> AVERAGEIF(range;"<>0").

Thanks for the pointer, but... well, I didn't find any MOYENNE.SI() (or
equivalent) in my FR version 4.1.4.2 Statistics functions. Thus my
suggestion to simulate one :,(

Hu? Yes, there is, but classified in the Math functions, while AVERAGE()
[MOYENNE() in FR] is classified in Statistics :,(

Thanks for the heads up.
-- 
Jean-Francois Nifenecker, Bordeaux

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted