Forum Discussion
Last 12 months counting
I am trying to produce a rolling 12 month count sheet that I have attached. In the large part, it works, but as explained in the workbook, sometimes when there is a cell with data that is not counted...
That link doesn't work for folks who aren't part of that particular sharepoint account. So you need to post a copy on OneDrive or GoogleDrive, pasting a link that actually grants access. Or a different category of link that grants access to your Sharepoint area.
- Thank you Mathetes- I have changed the link- would you mind checking that you can now see it?
Thanks again,
AlexisWhat is your definition of a "rolling 12 month count"?
What I have in mind with a rolling 12 months would be a far simpler formula than the one you have.
=SUM(Sheet1!D3:O3)All it does is get the 12 months up to and including the most recent. And that formula just can be copied across. But you can't begin doing that until the 12th month of any given series. (i.e., you can't do a rolling 12 months in the 10th month...)
- Well the problem is that one row can only be counted once in the last 12 months. Eg sheet 2 n2 is counted as it was the first time for 12 months that something other than 0 appeared. That's fine and works for most of what I need.
Row 2 is an exception. Sheet 2 A3 is counted- that's fine. I don't want to count December or Jan because it is within 12 months of Jan22. Again, that's fine. But Dec22 and Jan23 are stopping Feb 23 being counted. Feb 23 should be the 2nd time it's counted because it is 12 months on from the first count in Jan22. Does that make sense?
