Le 15/02/2014 16:59, william drescher a écrit :
> 
> Can anyone suggest a way of getting the average without needing to
> manually count the values ?
> 

Create your own "averageif()" function with a formula:

SUMIF() / COUNTIF()

-- 
Jean-Francois Nifenecker, Bordeaux

-- 
To unsubscribe e-mail to: users+unsubscr...@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

Reply via email to