Link to home
Create AccountLog in
Avatar of SPXHT
SPXHT

asked on

Backlog by Regions

All,

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.  :)

Good luck,

Pete
Backlog-by-Region.xlsx
Avatar of dlmille
dlmille
Flag of United States of America image

As a reality check, can you advise what the backlog totals should be for a couple months?  E.g., For February and March?

Dave
Avatar of SPXHT
SPXHT

ASKER

Sure Thing.

Attached as requested.

Pete
Backlog-by-Region.xlsx
So its Plus Current Month bookings and Minus Current Month pipeline, correct?
ASKER CERTIFIED SOLUTION
Avatar of dlmille
dlmille
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of SPXHT

ASKER

It appears your "sumproduct" formula is correct, I will audit it tomorrow and get back with you.

Thanks again Dave,

Pete
Avatar of SPXHT

ASKER

Dave,

Your formula works.  Quick request, for I am struggling on making the change myself.  I would like to extend the "ranges" on the three tabs well beyond the row paramaters you've covered, for we will be going way beyond this when dropping our data.  Everytime I try to replace with a wider range, my formula stops working.  Can you help?

Pete
Avatar of SPXHT

ASKER

Great work.
Sure.  I'm leaving for the airport in an hour.  Post your workbook that has the wider bounds and let me take a look.

Dave