Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Report Sum Base on ratio
I'm fairly new in VBA for excel and wondering if someone can help.
I have a spreadsheet which provides me with list of bids broken down in monthly revenue. The colomn count varies based on date range selection. I also have a column that holds a ratio which identifies the bid's win probability. Each record must hold the full monthly opportunity value but the monthly total sum is only based on the win probability ratio. Example: (Full Monthly Value) WinProb% Jan Feb Mar Apr 10% 100 100 100 100 20% 0 100 100 100 30% 0 0 100 100 40% 0 0 0 100 Total 10 30 60 100 If you need more info please let me know, Greatly appreciate the help, Norm |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Ratio | Setting up and Configuration of Excel | |||
How will I get report in Excel(2003) when my data base is in Access2003 | Excel Worksheet Functions | |||
Automate Excel report to place certain data into existing report? | Excel Worksheet Functions | |||
Divide x/y should give Ratio x:y,How to express ratio in excel | Excel Worksheet Functions | |||
Change base 6 to base 10? | Excel Discussion (Misc queries) |