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


Hi all,

Ok, just one more thing and I'll have this spreadsheet done for my boss...

Ok, we keep sales for Sales by month, with the Sales Rep in a Row and each month in a column...
So something like this:


        Jan
        Feb
        Mar
        Apr
        May
        Jun
        Jul
        Aug
        Sep
        Oct
        Nov
        Dec
        YTD
Sales Rep
        
        
        
        
        
        
        
        
        
        
        
        
        

        
        
        
        
        
        
        
        
        
        
        
        
        
Rep 1
        
        
        
        
        
        
        
        
        
        
        
        
        
Rep 2
        
        
        
        
        
        
        
        
        
        
        
        
        


What I'm trying to do is come up with a formula that can go in the YTD column that will SUM only Jan thru Jul for each Rep - and automatically change to SUM Jan thru Aug once we hit 8/1, etc...
Anyone have a clue? I've tried so many different permutations of 
SUMIF(), SUM(INDIRECT()), etc, and just can't figure this one out...
Thanks,

Charles

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