I have made this request pretty self explantory. I need in a given month a formula written that will add all remaining backlog past the current month applicable to that region, as it is assumed the current month has been executed + the current month bookings for that region - any expected revenues(pipeline). In February, the bookings will be cumulative for two months, and the pipeline will be cumulative reduction for regions. This will continue i.e. March will be (Jan, Feb, Mar). Backlog tab will always lose current month and back, and just add all columns for months going forward past current month when region is identified.
Sorry all, forgot to attach the file. :)