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...
Ah I see. I understand the confusion now- your summary is exactly it. I want a binary- yes I am counting you this month or not. The rolling 12 month was referring to always being the previous 12 months. Thanks for bearing with
There's still some ambiguity, though. (Sorry: this is why I was looking for a clear definition from the very start; and, yes, I can be very finicky about what I mean by clear definitions).
Do you want to know the number of months that a person appeared during the preceding 12 months, or only that they appeared at least once during the preceding 12 months.
In other words, is it
- binary for 12 months, so your 12 month summary will be either 1 or zero, Yes or No; ,
or
- binary for each of the preceding 12 months, so the rolling 12 months could be any number up to 12.
Does this do it?
=IF(SUM(Sheet1!C2:N2)>0,"Yes","")
Copied forward; the relative references change to always be dealing with the "most recent twelve months"
- Hello,
No problem. I have been there too before asking similar questions.
I would like binary for 12 months- just have they appeared in the last 12 months or not.
If you could make that work that would be amazing!