Hi folks,

I'm looking for some formula help in Excel.

Basically I have a set of figures as follows:

Bob Date 1 Jan 2 Jan 3 Jan
Value 1 10 10 10
Value 2 5 5 5

I want a formula which figures out the average percentage of value 2
compared to value 1 - i.e. Value 2 for 1st to 3rd Jan, divided by Value 1 for
1st to 3rd Jan.

However, the formula would have to take into account some days will have no
entries in either Value, and that sometimes value 2 will be 0, even when
there is an entry in Value 1 for the same date. i.e.

Bob Date 1 Jan 2 Jan 3 Jan
Value 1 10 10 10
Value 2 5 0 5

The forumula I have just now would give me the same result for both of these
examples - 50%, when the 2nd example should be 33%.

Thanks to anyone who can help me with this.

Steve