| record sheet.xlsx | |||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | J | K | L | M | |||
| 1 | Q / case | £ / case | person a | person b | c | d | e | ||||||||
| 2 | Udon | 60 | £5 / 6 | 6 | $ 5.00 | 6 | $ 5.00 | ||||||||
| 3 | Nori | 10 | £ 7.50 | 1 | $ 7.50 | ||||||||||
| 4 | Edamame | 20 | £ 2.50 | 2 | $ 5.00 | 1 | $ 2.50 | 3 | £ 7.50 | 1 | £ 2.50 | ||||
| 5 | katsu | 10 | £ 12.00 | 1 | $ 12.00 | $ - | 1 | £ 12.00 | 1 | £ 12.00 | |||||
| 6 | Gyoza | 10 | £ 6.00 | $ - | 1 | $ 6.00 | £ - | 1 | £ 6.00 | ||||||
| 7 | Ramen | 7 | £ 10.00 | $ - | $ - | 2 | £ 20.00 | £ - | |||||||
| 8 | Prawn | 12 | £ 6.50 | 1 | $ 6.50 | $ - | 3 | £ 19.50 | 2 | £ 13.00 | |||||
| 9 | Dorayaki | 50 | £ 1.50 | 2 | $ 3.00 | 10 | £ 15.00 | $ - | 10 | £ 15.00 | £ - | ||||
| 10 | $ - | $ - | £ - | £ - | |||||||||||
| 11 | 179 | 13 | $ 39.00 | 10 | $ 15.00 | 8 | $ 13.50 | 19 | $ 74.00 | 5 | $ 33.50 | ||||
| 12 | 55 | ||||||||||||||
| 13 | $ 175.00 | ||||||||||||||
| 14 | |||||||||||||||
| 15 | |||||||||||||||
| 16 | |||||||||||||||
| 17 | |||||||||||||||
| 18 | 1 | how can I make this table more efficient? | |||||||||||||
| 19 | 2 | is there a formula that the sum can auto add up if new entries are made? | |||||||||||||
| 20 | 3 | is there a formula that when the quantity is entered under a person, the price than auto calculated? | |||||||||||||
| 21 | |||||||||||||||
Sheet1 | |||||||||||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| G9 | G9 | =F9*C9 |
| E3:E10 | E3 | =D3*C3 |
| I4:I10 | I4 | =H4*C4 |
| K4:K10 | K4 | =J4*C4 |
| M4:M10 | M4 | =L4*C4 |
| B11,D11:M11 | D11 | =SUM(D2:D10) |
| B12 | B12 | =D11+F11+H11+J11+L11+N11+P11+R11+T11+V11+X11+Z11+AB11+AD11+AF11+AH11 |
| B13 | B13 | =SUM(E11+G11+I11+K11+M11) |
| Cells with Conditional Formatting | ||||
|---|---|---|---|---|
| Cell | Condition | Cell Format | Stop If True | |
| A1:D1,F1,H1,J1,L1,A2:M12 | Expression | =ROW()=CELL("row") | text | NO |
