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.

	A	B	C	D	E	F	G	H	I	J
1		wk1	wk1	wk1 Total	wk2	wk2	wk2 total	Main total
2		activity 1	activity 2		activity 1	activity 2				Average Formula
3	Cust1	6	6	12	7	10	17	29		14.5
4	Cust2	9	2	11	2	3	5	16		8
5	Cust3	4	1	5						2.5
6	Cust4	1	2	3	1	8	9	12		6
7	Cust5				8	2	10	10		10
8	Cust6	4	3	7	3	8	11	18		9

<tbody>
</tbody>