Spreadsheet help please

[Jak68]

I am looking to create a spreadsheet to keep a track on the food that staff are purchasing.

I am looking to record the staff members name, food purchased, the price related to the food purchased, also to be able to show how much the staff member has spent in total at any time.

I am waiting for the staff names to copy into the spreadsheet and also the pricing for the individual food items, I just need a bit of help of where to start with it?

Thanks

 

[Jak68]

I hope this works ok as I have not used the Xl2bb add on before.

This is the first page of a spreadsheet I have found that can be tweaked, the green text/prices is what I want to add:

Friday Breakfast List.xlsx
	A	B	C	D	E	F	G	H	I	J	K
1	Name	Choice 1	Choice 2	Choice 3	Choice 4	Price			Prices
2		Sausage				£1.20
3						#N/A			1 Item	£1.20
4						#N/A			2 Items	£1.50
5						#N/A			3 Items	£1.70
6						#N/A			4 Items	£2.00
7						#N/A			Main	£2.00
8						#N/A			Salad	£2.00
9						#N/A			Sandwich	£1.00
10						#N/A
11						#N/A
Sheet1

Cell Formulas
Range	Formula
F2:F11	F2	=VLOOKUP((COUNTA(B2:E2)),Sheet2!$A$6:$B$9,2,0)

Cells with Data Validation
Cell	Allow	Criteria
B1:E11	List	=Sheet2!$A$1:$A$4

This is sheet 2:

Friday Breakfast List.xlsx
	A	B
1	Bacon
2	Sausage
3	Egg
4	Black Pudding
5
6	1	£1.20
7	2	£1.50
8	3	£1.70
9	4	£2.00
10
Sheet2