Date: prev next · Thread: first prev next last
2015 Archives by date, by thread · List index



Hi Folks ..


I need to be able to select  the last 3 in a series of cells that change on a weekly
basis 



so i week 1 there would be 1 cell  no action 
week 2                              2 cells  no action 
week 3                          3 cell sum three cells 
week 4                          4 cells sum last three
week 5                          5 cells sum last three  

and so it goes on for 8 weeks always just summing the last 3 cells in the
series  then divide by 3 subtract 30 = result ..


Pete 

     



-- 
Illegitimi non carborundum . ro for the purists out there
Noli nothis permittere te terere. 

-- 
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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.