I currently have the following populated in a spreadsheet:
A B C
1 Plan Actual
2 Jan $10.00 $10.00
3 Feb $10.00 $10.00
4 Mar $10.00
5 Apr $10.00
6 May $10.00
7 Jun $10.00
8 Jul $10.00
9 Aug $10.00
10Sep $10.00
11Oct $10.00
12Nov $10.00
13Dec $10.00
14YTD $120.00 $20.00
15 17%

The information in B 14 & c14 is a sum of the cells above. What I am
wanting in C15 is c14/c15 as a % but only upto the where column C is
populated. For example, Jan & Feb are populated so I want C15 to be a
(c2+c3)/(B2+b3) which shoud result 100%, but then if C4 is populated with $5
I want C15 to automatically be (c2+c3+c4)/(b2+b3+b4) which should result 83%,
and so on.

Thanks