SpreadEveryone: The Fetchland Excel wire

101 watchers

Diogenes Jul 2019 5:15pm, 31 Jul 2019 39,003 posts	0 Diogenes (I used the centre across selection tip today)
um Jul 2019 5:30pm, 31 Jul 2019 1,126 posts	0 um Larkim Since the data is somewhat unstructured - I'd 1) ignore the cumulative column 2) add a 'number of days' and 'average use/day column' 3) then either manually - or otherwise - add a column giving sum of (days*daily use) for the periods you want, ie 3a) you could set a further sheet with all calendar dates and paste/vlookup/if formula for the ave daily use or 3b) set artificial entries in the original for the dates you want to track to
SPR Jul 2019 6:33pm, 31 Jul 2019 28,824 posts	0 SPR This should work if I've read the problem correctly. Sumifs(Data, Dates, greater than EDATE(@Date,-12)
SPR Jul 2019 6:35pm, 31 Jul 2019 28,825 posts	0 SPR Assuming you're selecting whole column rather than data immediately above each date, modify to Sumifs(Data, Dates, greater than EDATE(@Date,-12), Dates, less than or equal to @Date))
larkim Aug 2019 11:55am, 1 Aug 2019 8,263 posts	0 larkim Nice SPR, thanks - that second one did the trick, once I'd faffed around with the correct placing for "" in the sumifs conditions. Working in Google Sheets, I presume it would work the same in Excel.
GregP Aug 2019 9:49pm, 1 Aug 2019 113,656 posts	0 GregP Nice work Young ‘Un
quimby Aug 2019 4:58am, 31 Aug 2019 4,356 posts	0 quimby I am interesting in your "what I last used a spreadsheet for" facts. Mine: working out how old Mark E Smith of The Fall would have been if he was still alive today. Last but one was a 29 page A3 plan for a production software upgrade.
GregP Aug 2019 7:04am, 31 Aug 2019 114,326 posts	0 GregP Im building a marginal gains engine for S&G. ‘Centre across’ is a bit Gherkin for drop-down selections.
Pothunter Aug 2019 7:08am, 31 Aug 2019 1,521 posts	0 Pothunter Analysis of inbound wage type data so more of a temporary repository but there was a vlookup involved
um Aug 2019 8:21am, 31 Aug 2019 1,191 posts	0 um I have 2 at the moment ... 1) Tracking running miles & weight 2) October Oz trip planning