[libreoffice-users] DUM dynamic range (based on current date/month)

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