Report Sum Base on ratio

  • Thread starter Norman Belanger
  • Start date
N

Norman Belanger

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple If statements, Calculating quarterly % holding costs 0
crosstab problem 2
formatting report using crosstab query 3
Custom Macro for pulling information into one sheet 0
Copy from sheet1 and sheet2 and append to sheet3 in different format 13
How to dynamically add up varying # of cells base on a value 6
Determining EVERY month between 2 given dates 17
sum cluster of cells based on values 1

Top