I am trying to work out how much my client contracts are worth in each financial year for the next 5 years but I think the type of formula is a bit beyond me! Below is a screenshot of the data I have and what I'm trying to do. I'd appreciate any help!
Capture.PNG
please dont post images
Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
example_file.xlsx
Sorry, file attached.
i can do it like this but had to use another sheet(sheet2!) to split the months to each year
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks