LinkBack URL
About LinkBacks
sjpeters75 
Try explaining ne of your expected results: how EXACTLY have you calculated $168 in B25? What is the manual calculation that gets you there? If we know that, we can offer a suggestion.
Try explaining ne of your expected results: how EXACTLY have you calculated $168 in B25? What is the manual calculation that gets you there? If we know that, we can offer a suggestion.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Hi Ali,
Thank you for coaching me through this! First, I'm going to apologize, and then I'm going to hide under a rock because my manual calculations for Contract 1 were wrong.
Please take a look at my revised file attached.
The formula for a single opportunity is (Rev/hr) * (8 hrs/day) * the overlapping workdays between the start and end of the opportunity and the calendar month; this formula is correctly represented in B30:M31.
However, I want the summary table (B17:M19) to show the sum of all opportunities for a given contract in the date range.
Thank you again for your kind assistance.
Respectfully and gratefully,
steve
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks