Excel Two variable table help please

[LukeRiv]

I need to make a two variable table for two different products.

The products are jumpers and pullovers.

The jumpers go up to 200 and pullovers up to 400. Both going up in 10s.

Jumpers cost $26 and pullovers $18.

So it needs to go like this:

0 10 20 30 40
0
10
20
etc

It needs to show the max profit but i dont know how to get it to work. Any help?

[Olly]

Give us a clue - how do you measure the profit, for any given combination of jumpers / pullovers?

[LukeRiv]

Have the selling price as stated above and the amount sold is 0-400 and 0-200. So it would be 10x$18 etc

[Olly]

Okay, so there's no profit calculation, you just want total sales revenue, based on the number of jumpers and pullovers sold?

# Jumpers in Row 1, # Pullovers in Column 1:

	A	B	C	D
1		0	10	20
2	0	$0	$260	$520
3	10	$180	$440	$700
4	20	$360	$620	$880

It's the same formula copied across / down:

	A	B	C	D
1		0	10	20
2	0	=(B$1*26)+($A2*18)	=(C$1*26)+($A2*18)	=(D$1*26)+($A2*18)
3	10	=(B$1*26)+($A3*18)	=(C$1*26)+($A3*18)	=(D$1*26)+($A3*18)
4	20	=(B$1*26)+($A4*18)	=(C$1*26)+($A4*18)	=(D$1*26)+($A4*18)