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 <tansta...@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+unsubscr...@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+unsubscr...@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