Customer have scheduled weekly payment, each new weekly customer starts from the beginnig.

Edit There are extra spaces in Frequency column (C). Those have to be removed for this to work.

For starters you can simplify G10:M12 with this formula

Formula:

Please Login or Register  to view this content.

I am still working on the rest.

In G4:M6

Formula:

Please Login or Register  to view this content.

Between those two formulas you get the matrices you wanted ... I think.

	F	G	H	I	J	K	L	M
1
2	Field	Week 1	Week 2	Week 3	Week 4	Week 5	Week 6	Week 7
3	Quantity	12	7	6	4	6	3	8
4	Phase 1	6,000	3,500	3,000	2,000	3,000	1,500	4,000
5	Phase 2	-	2,800	2,400	1,600	2,400	1,200	3,200
6	Phase 3	-	4,200	3,600	2,400	3,600	1,800	4,800
7	Revenue	6,000	10,500	9,000	6,000	9,000	4,500	12,000
8
9	Phase	Week 1	Week 2	Week 3	Week 4	Week 5	Week 6	Week 7
10	Phase 1	500	-	-	-	-	-	-
11	Phase 2	-	400	-	-	-	-	-
12	Phase 3	-	600	-	-	-	-	-

Another way.

Skip the bottom matrix and just do this in G4:M6

Formula:

Please Login or Register  to view this content.

Another way to avoid the bottom matrix and without the IFERROR calls. In G4:M6

Formula:

Please Login or Register  to view this content.

You are welcome. Thank you for the feedback.

BTW: I got a little over exuberant with that last formula. It can be shortened/simplified with

Formula:

Please Login or Register  to view this content.

When comparisons such as ($F4=$B$3:$B$18) are calculated they return an array of TRUE/FALSE. TRUE/FALSE have underlying numeric values of 1/0. The "--" is one way of coercing those numeric values. Also an arithmetic operation will do the same ... *1, +0, ^1, /1.

If you select one of the cells with that formula, click Formulas > Evaluate formula and click Evaluate repeatedly Excel shows step by step how it calculates the formula. In this case you will see the TRUE/FALSE to 1/0 happening.