Dynamic count rows then divide formula needed

[halesowenmum]

Hi

I need a formula to take what's here and 'automate' it (that's the only way I know to describe it).

Here we've got a manually entered range but it's this bit that needs to just do it's thing without being manually entered and I just don't know how to do it. It needs to accommodate changing numbers of rows where the rows are used to calculate the overall %. There are too many of these sections in the spreadsheet and they all have variable numbers of rows involved, to have a manually entered formula which will need manually editing many times.

Is there a way of doing what I need with a formula or VBA???

	E	F	[My comment]
14	Overall progress	13%	Formula in F14 [=SUM(F14:F66)/COUNT(F14:F16)] sums the range then divides by number of rows in the range that contain values not formulas. This total in G is meant to be formed from the underlying values provided in rows 15 and 16 - only when all were complete would the total in G14 = 100%. The formula doesn't count F17 as it contains a formula so it stops at F16.
15	This item	20%	This value is manually entered by the user
16	This item	5%	This value is manually entered by the user
17	Overall progress	66%	This value is manually entered by the user
18	This item	100%	The number of rows can be different in each case, rows can be removed, new rows can be added
19	This item	90%	This value is manually entered by the user
20	This item	70%	This value is manually entered by the user
21	This item	3%	This value is manually entered by the user

 

[halesowenmum]

Would INDEX and COUNT work somehow - I just don't know how to construct the formula....

 

[halesowenmum]

Anyone??