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

2014-07-21 Thread James Knott
On 07/21/2014 08:39 AM, Tanstaafl wrote: > was working on a 'wtf?' Is that the new MS Office format? ;-) -- 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.

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

2014-07-21 Thread Tanstaafl
On 7/20/2014 1:54 PM, Florian Reisinger wrote: Without trying, so not exact names If(month(today()) < 8; sum(jan-jul);sum(aug-dez)) Hope this helps... Hmmm... yeah, I guess I could create a named range for each possible period - jan, jan-feb, jan-mar, etc - then do it ion a nested IF, but I'

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

2014-07-21 Thread Tanstaafl
Thanks for the reply Paul, I was working on a 'wtf?' reply as to why the list converted my HTML email (had the values in a simple table) to plain text. Also, I have no clue what happened with the 'DUM' in the subject - I didn't type that... weirdness... Blindly converting HTML to plain text

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

2014-07-20 Thread Brian Barker
At 13:47 20/07/2014 -0400, Charles Marcus wrote: ... 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 com

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

2014-07-20 Thread Paul
On Sun, 20 Jul 2014 13:47:35 -0400 Tanstaafl wrote: > Hi all, > > Ok, we keep sales for Sales by month, with the Sales Rep in a Row and > each month in a column... Sounds simple, but... > So something like this: This didn't come through properly (my email client does text by default, and did

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

2014-07-20 Thread Florian Reisinger
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 : > > Hi all, > > Ok, just one more thing and I'll have this spreadsheet done for my boss... > > Ok, we

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

2014-07-20 Thread Tanstaafl
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