Dear excel funs, reporting colleagues, ...
I would like to ask you for help with an idea how to make 12 months floating summary for each line.
Enclosed, you have a file with data-example.
So far, I found a formula to ask for the last cell, so I can add it in formula 12 times, but I am sure, there is a better way. SUMMIFS with some condition in additional row (if(actual date is lover than (now - 12); 1; 0) - summifs 1.
but it seems not nice to me.
Thanks for idea.
Bookmarks