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

Hi,
Without trying, so not exact names
If(month(today()) < 8; sum(jan-jul);sum(aug-dez))
Hope this helps...

Liebe Grüße, / Yours,
Florian Reisinger

> Am 20.07.2014 um 19:47 schrieb Tanstaafl <tanstaafl@libertytrek.org>:
>
> 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

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