Averageif MOD formula help needed

[Superman01]

Hi All,

Imagine Range(A1-H8) is a pivot.
I would like help with the formula down (column J) next to Pivot to see what the average sales of each customer is.

The problems I'm facing are:

• Include weeks which have zero data as long as they've had previous sales Cust 3.
• the average only starts calculating when they start sales. ie comparing Cust 3 vs Cust 5.
• Next week when I run data for week 3, I can just copy formula from Column J into column M and the formula will include week 3's data when I refresh the pivot.

Thanks in advance.

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[TD]J[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD][/TD]
[TD]wk1[/TD]
[TD]wk1[/TD]
[TD]wk1 Total[/TD]
[TD]wk2[/TD]
[TD]wk2[/TD]
[TD]wk2 total[/TD]
[TD]Main total[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD][/TD]
[TD]activity 1[/TD]
[TD]activity 2[/TD]
[TD][/TD]
[TD]activity 1[/TD]
[TD]activity 2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Average Formula[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Cust1[/TD]
[TD]6[/TD]
[TD]6[/TD]
[TD]12[/TD]
[TD]7[/TD]
[TD]10[/TD]
[TD]17[/TD]
[TD]29[/TD]
[TD][/TD]
[TD]14.5[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Cust2[/TD]
[TD]9[/TD]
[TD]2[/TD]
[TD]11[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]5[/TD]
[TD]16[/TD]
[TD][/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]Cust3[/TD]
[TD]4[/TD]
[TD]1[/TD]
[TD]5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]2.5[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]Cust4[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]1[/TD]
[TD]8[/TD]
[TD]9[/TD]
[TD]12[/TD]
[TD][/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]Cust5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]8[/TD]
[TD]2[/TD]
[TD]10[/TD]
[TD]10[/TD]
[TD][/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]Cust6[/TD]
[TD]4[/TD]
[TD]3[/TD]
[TD]7[/TD]
[TD]3[/TD]
[TD]8[/TD]
[TD]11[/TD]
[TD]18[/TD]
[TD][/TD]
[TD]9[/TD]
[/TR]
</tbody>[/TABLE]